Question

The Master Budget 555 PROBLEMS Group A P9-54A Comprehensive budgeting problem (Le Damon Manufacturing is preparing its master
j. Damon Manufacturing has a policy that the ending cash balance in each month must be at least $4,000. It has a line of cred
2. Prepare a production budget, using the following format: ABC Production Budget For the Quarter Ended March 31 Month Januar
0 0
Add a comment Improve this question Transcribed image text
Answer #1
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
Add a comment
Know the answer?
Add Answer to:
The Master Budget 555 PROBLEMS Group A P9-54A Comprehensive budgeting problem (Le Damon Manufacturing is preparing...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT