Endless Mountain Company manufactures a single product that is popular with outd
ID: 2568318 • Letter: E
Question
Endless Mountain Company manufactures a single product that is popular with outdore recreation enthusiasts. The company sells its product to retailers throughout the northeastern quadrant of the United States. It is in the process of creating a master budget for 2017. The company's CFO in consultation with various managers across the company is providing the latest Balance Sheet and a set of assumptions to help create the 2017 budgets.
Using the list of Assumptions and the Balance Sheet provided below do the following:
A. Create a SALES BUDGET for the year ended December 31, 2017.
B. Create a SCHEDULE OF EXPECTED CASH COLLECTIONS for the year ended December 31, 2017.
C. Create a PRODUCTION BUDGET for the year ended December 31, 2017.
List of Assumptions:
Endless Mountain Company manufactures a single product that is popular with outdore recreation enthusiasts. The company sells its product to retailers throughout the northeastern quadrant of the United States. It is in the process of creating a master budget for 2017. The company's CFO in consultation with various managers across the company is providing the latest Balance Sheet and a set of assumptions to help create the 2017 budgets.
Using the list of Assumptions and the Balance Sheet provided below do the following:
A. Create a SALES BUDGET for the year ended December 31, 2017.
B. Create a SCHEDULE OF EXPECTED CASH COLLECTIONS for the year ended December 31, 2017.
C. Create a PRODUCTION BUDGET for the year ended December 31, 2017.
List of Assumptions:
Budgeted Unit sales 01 2017 Q2 2017 Q3 2017 04 2017 Q1 2018 12,000 37,000 15,000 25,000 13,000 Budgeted Selling Price per unit 32 All sales are credit sales gnore Uncollectible Accounts. They are minimal Percentage of Sales collected in the quarter of the sale Percentage of Sales collected in the subsequent quarter 75% 25% Quarter ending finished goods inventory as a percent of next quarter's unit sales Yards of raw material required for each unit Cost per yard of raw material Quarter ending raw materials inventory as a percent of next quarter's production needs Estimated ending raw materials inventory on December 31, 2017 (in yards) Percent of purchases paid for in the quarter of the purchase Percent of purchases paid for in the quarter following the purchase 15% 3.5 3.00 10% 5,000 70% 30% Direct labor hourly rate Direct labor hours required to finish each unit of finished goods Direct labor hours are paid in the quarter incurred 18.00 0.25 Budgeted variable manufacturing overhead per direct labor-hour Quarterly fixed manufacturing overhead (including depreciation expense on equipment) Quarterly depreciation on equipment The number of direct labor hours is used as the allocation base for the budgeted plantwide overhead rate 3.00 $ 150,000 20,000Explanation / Answer
Answer 1. Sales Budget Year 2017 Total Q1 Q2 Q3 Q4 Sales in Units 12,000 37,000 15,000 25,000 89,000 Sp Per Unit 32.00 32.00 32.00 32.00 32.00 Total Sales in $ 384,000 1,184,000 480,000 800,000 2,848,000 Answer 2. Schedule of Expected Cash Collections from Sales Year 2017 Total Q1 Q2 Q3 Q4 Collection from Accounts Receivables Accounts Receivable - Dec 31, 2016 260,000 260,000 Q1 Sales 288,000 96,000 384,000 Q2 Sales 888,000 296,000 1,184,000 Q3 Sales 360,000 120,000 480,000 Q4 Sales 600,000 600,000 Total cash Collections 548,000 984,000 656,000 720,000 2,908,000 Answer 3. Merchandise Production Budget Year 2017 Total Q1 Q2 Q3 Q4 Sales In units 12,000 37,000 15,000 25,000 89,000 Add: Ending Inventory - 15% 5,550 2,250 3,750 1,950 1,950 Total Needs 17,550 39,250 18,750 26,950 90,950 Less: Beginning Inventory (1,500) (5,550) (2,250) (3,750) (1,500) Required Units Produced 16,050 33,700 16,500 23,200 89,450
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.