Question

#### Homework Answers

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
Know the answer?
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

Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?

Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
Active Questions
ADVERTISEMENT