1 | Cash Collection Budget | |||||||||
January | February | March | Quarter | |||||||
Cash Sales@35% of total sales | $ 34,860 | =99600*35% | $ 41,580 | =118800*35% | $ 40,320 | =115200*35% | 116,760 | It is 35% of current month sale | ||
Credit Sales | $ 46,150 | =71000*65% | $ 64,740 | =99600*65% | $ 77,220 | =118800*65% | 188,110 | It is 65% of last month sale | ||
Total Cash Collection | $ 81,010 | $ 106,320 | $ 117,540 | 304,870 | ||||||
2 | January | February | March | Quarter | April | |||||
Unit Sales | 8,300 | =99600/12 | 9900 | =118800/12 | 9600 | =115200/12 | 27,800 | 9,000 | ||
Plus desired inventory at end | 990 | =9900*10% | 960 | =9600*10% | 900 | =9000*10% | 900 | (10% of next month sales unit) | 860 | |
Total needs | 9,290 | 10,860 | 10,500 | 28,700 | 9,860 | |||||
Less:Estimated inventory at beginning | 830 | 8300*10% | 990 | 960 | 830 | Beginning inventory would be closing inventory of previous month | 900 | |||
Total units to be produced | 8,460 | 9,870 | 9,540 | 27,870 | 8,960 | |||||
3 | Direct Material Budget | |||||||||
January | February | March | Quarter | April | ||||||
Units to be produced (from Production Budget) | 8,460 | 9,870 | 9,540 | 27,870 | 8,960 | |||||
Mutiply by:Quantity (pound) of DM needed per unit | 3 | 3 | 3 | 3 | 3 | |||||
Quantity pounds needed for production | 25,380 | 29,610 | 28,620 | 83,610 | 26,880 | |||||
Add:desired ending inventory of DM | 5,922 | =29610*20% | 5,724 | =28620*20% | 5,376 | =26880*20% | 5,376 | (20% of next month production need) | ||
Total Needs | 31,302 | 35,334 | 33,996 | 88,986 | ||||||
Less:Beginning raw material | 5076 | =25380*20% | 5,922 | 5,724 | 5076 | |||||
Raw material to be purchased | 26,226 | 29,412 | 28,272 | 83,910 | ||||||
Mutilpy by:Cost per pound | $ 2 | $ 2 | $ 2 | $ 2 | ||||||
Total cost of DM purchases | $ 52,452 | $ 58,824 | $ 56,544 | $ 167,820 | ||||||
The Master Budget 555 PROBLEMS Group A P9-54A Comprehensive budgeting problem (Le Damon Manufacturing is preparing...
Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalley Manufacturing's operations: (Click the icon to view the data.) (Click the icon to view additional data.) Read the requirements. Requirement 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. Dalley Manufacturing Cash Collections Budget For the Quarter Ended March 31 Month January February March Quarter Cash sales Credits sales Total...
Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to deckers manufacturing s operation Current Assets as of December 31 (prior year): Cash 4600 Accounts receivable, net 47000 Inventory 15100 Property, plant, and equipment, net 123000 Accounts payable. 43000 Capital stock. 123500 Retained earnings. 23100 a. Actual sales in December were $71,000. Selling price per unit is projected to remain stable at $12 per unit throughout the budget period. Sales...
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: January 40,000 February 50,000 March 60,000 April 60,000 May 62,000 The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: Finished goods inventory on January 1 is 32,000 units, each costing $166.06. The desired ending inventory for each...
Question 1 Dudley Manufacturing is preparing its master budget for the first month of the upcoming year. The following data pertain to ar East Manufacturing's operations: • Account Balances as at December 31(prior year): Cash RM4,500 Account Receivable, net RM50,000 Inventory RM15,000 Account Payable RM42,400 Actual sales in December were RM70,000. Selling price per unit is projected to remain stable at RM10 per unit throughout the budget period. Sales for the first two months of the upcoming year are budgeted...
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: January 40,000 February 50,000 March 60,000 April 60,000 May 62,000 The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: 1 a. Finished goods inventory on January 1 is 32,000 units, each costing $166.06. The desired ending inventory...
Section B - Please answer ALL questions. Question 1 Dudley Manufacturing is preparing its master budget for the first month of the upcoming year. The following data pertain to Far East Manufacturing's operations: • Account Balances as at December 31(prior year): Cash RM4,500 * Account Receivable, net RM50,000 Inventory RM15,000 Account Payable RM42,400 Actual sales in December were RM70,000. Selling price per unit is projected to remain stable at RM10 per unit throughout the budget period. Sales for the first...
3. Prena 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. 2. Prepare a production budget. (Hint: Unit sales - Sales in dollars / Selling price per unit.) Prepare a direct materials budget. 4. Prepare a cash payments budget for the direct material purchases from Requirement 3. 5. Prepare a cash payments budget for direct labor. 6. Prepare a cash payments budget for manufacturing overhead costs. 7. Prepare a cash payments...
Trebblehorn Industries has adopted the following sales budget for the first 3 months of 2017. Month Units January 11,000 February 15,000 March 13,000 Management requires 30% of next month sales to be in ending inventory. Each unit requires 5 pounds of raw materials costing $3 per pound. Management wants to have a raw materials inventory at the end of the month equal to 35% of next month's production requirements. April's expected sales are 12,000 with a total of 13,500 required...
X € Inbox (88) - jpainter5 x y Home / Twitter x (2) YouTube X Pearson eText x Pearson eText x C Managerial Accountin x + - + c etext.pearson.com/eplayer/pdfbook?bookid=46432&platform=1030&smsuserid=93761992&scenario=11&invoketype=et1&bookserver=1&pagenumber=i&c... E ☆ 555 > во А4 : P9-54A Comprehensive budgeting problem (Learning Objectives 2 & 3) Damon Manufacturing is preparing its master budget for the first quarter of the upcom- ing year. The following data pertain to Damon Manufacturing's operations: Current Assets as of December 31 (prior year): Cash. Accounts...
Stenback Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first five months of the upcoming year show the estimated unit sales of the planters each month to be as follows: (Click the icon to view additional information.) Inventory at the start of the year was 800 planters. The desired inventory of planters at the end of each month should be equal to 25% of the following month's budgeted sales. Each planter requires two pounds...