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 quarters 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 quarters 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,000 //<[CDATA[ (function(){window.pagespeed=window.pagespeed||{};var a=window.pagespeed;function b(){}b.prototype.a=function(d,e,c){if(d=document.getElementById(d))if(e=document.getElementById(e))if(c=document.getElementById(c))e.src=d.getAttribute(“src”),c.parentNode.removeChild(c)};b.prototype.inlineImg=b.prototype.a;a.b=function(){a.dedupInlinedImages=new b};a.dedupInlinedImagesInit=a.b;})(); pagespeed.dedupInlinedImagesInit(); //]]>//<[CDATA[ pagespeed.dedupInlinedImages.inlineImg('pagespeed_img_tDk-KmT9S31','pagespeed_img_tDk-KmT9S32','pagespeed_script_3'); //]]>

//<[CDATA[ pagespeed.dedupInlinedImages.inlineImg('pagespeed_img_tDk-KmT9S31','pagespeed_img_tDk-KmT9S34','pagespeed_script_5'); //]]>

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,000