Question

3. Prena 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. 2. Prepare

Requirement 3. Prepare a direct materials budget. (Round your answers to the nearest whole dollar.) Decker Manufacturing Dire

Requirement 4. Prepare a cash payments budget for the direct material purchases from Requirement 3. (Round your answers to th

Requirement 6. Prepare a cash payments budget for manufacturing overhead costs. (Round your answers to the nearest whole doll

Requirement 8. Prepare a combined cash budget. (If a box is not used in the table leave the box empty; do not enter a zero. U

Requirement 9. Calculate the budgeted manufacturing cost per unit (assume that fixed manufacturing overhead is budgeted to be

Requirement 10. Prepare a budgeted income statement for the quarter ending March 31. (Hint: Cost of goods sold = Budgeted cos* Data Table Current Assets as of December 31 (prior year): Cash Accounts receivable, net ....... Inventory Property, plant,

a. Actual sales in December were $71,000. Selling price per unit is projected to remain stable at $12 per unit throughout the

i. Depreciation on the building and equipment for the general and administrative offices is budgeted to be $5,000 for the ent

0 0
Add a comment Improve this question Transcribed image text
Answer #1
1 Cash collections budget
Month
Jan Feb Mar Quarter
Cash sales 34860 41580 40320 116760
(Current month sales*35%) (99600*35%) (118800*35%) (115200*35%)
Credit sales 46150 64740 77220 188110
(Previous month sales*65%) (71000*65%) (99600*65%) (118800*65%)
Total cash collections 81010 106320 117540 304870
2 Production budget
Month
Jan Feb Mar Quarter
Unit sales (Note:1) 8300 9900 9600 27800
Plus:Desired ending inventory 990 960 900 2850
(Following months sales*10%) (9900*10%) (9600*10%) (9000*10%)
Total needed 9290 10860 10500 30650
Less: Beginning inventory 830 990 960 2780
(Ending inventory of previous month) (8300*10%)
Units to produce 8460 9870 9540 27870
Note:1
Jan Feb Mar Apr
Sales in $ a 99600 118800 115200 108000
Selling price per unit b 12 12 12 12
Unit sales a/b 8300 9900 9600 9000
3 Direct materials budget
Month
Jan Feb Mar Quarter April
Units to be produced 8460 9870 9540 27870 9000
Multiply by:Quantity (pounds) of DM needed per unit 3 3 3 3
Quantity (pounds) needed for production 25380 29610 28620 83610 27000
Plus: Desired ending inventory of DM 5922 5724 5400 17046
(Next month production needs*20%) (29610*20%) (28620*20%) (27000*20%)
Total quantity (pounds) needed 31302 35334 34020 100656
Less: Beginning inventory of DM 5076 5922 5724 16722
(Ending inventory of previous month) (25380*20%)
Quantity (pounds) to purchase 26226 29412 28296 83934
Multiply by:Cost per pound 2 2 2
Total cost of DM purchases 26224 29410 28294 83928
4 Cash payments for direct materials budget
Month
Jan Feb Mar Quarter
20% of current month DM purchases 5245 5882 5659 16786
(26224*20%) (29410*20%) (28294*20%)
80% of last month's DM purchases 43000 20979 23528 87507
Accounts payable (26224*80%) (29410*80%)
Total cash payments 48245 26861 29187 104293
5 Cash payments for direct labor budget
Month
Jan Feb Mar Quarter
Total cost of direct labor 3807 4442 4293 12542
Add a comment
Know the answer?
Add Answer to:
3. Prena 1. Prepare a schedule of cash collections for January, February, and March, and for...
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
  • 1) Prepare a schedule of cash collections for ianuary February and March, and for the quarter...

    1) Prepare a schedule of cash collections for ianuary February and March, and for the quarter in totall. Use the following format: Quarter 27500 16000 25070 February March 24000 29700 Credit Sales 64400 Total cash collection 71000 33600 100 (2) Prepare a production budget, using the following format January February March 9900 Plus: Der ending investory 210 275 2425 Total needed 10100 11675 12325 Less: Beginning inventory 2000 Units to produce 9850 *Hunt: Units sales Sales in dollars/Seng price per...

  • Projected sales in units for the coming 5 months follow: January 40,000 February 50,000 March 60,000...

    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 Finished goods inventory on January 1 is 32,000 units, each costing $166.06. The desired ending inventory for each month is 80% of the next month's sales. The data on materials used are as follows: Direct Material Per-Unit Usage DM Unit Cost ($) Metal 10 lbs. 8 Components 6 5 Inventory policy dictates that sufficient materials be on hand at the...

  • Requirement 1. Prepare Cooke Company's schedule of cash receipts from customers and schedule of cash payments...

    Requirement 1. Prepare Cooke Company's schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2018 Begin by preparing the schedule of cash receipts from customers for the first quarter of 2018 Cash Receipts from Customers First Quarter 2018 i Data Table Total sales Cash Receipts from Customers: Accounts Receivable balance, December 31, 2017 1st Qtr-Sales Total cash receipts from customers Total sales Budgeted purchases of direct materials Budgeted direct labor cost Budgeted manufacturing...

  • Needing help with this! I have been working on this question for over 2 hours! If anyone could pl...

    Needing help with this! I have been working on this question for over 2 hours! If anyone could please help me out as it is due tomorrow morning at 8am! if you do ill be forever in debt!. Homework: Chapter 9 Homework Score: 0.12 of 1 pt & P9-57A (similar to) Save 2 of 4 (3 complete) HW Score: 39.12%, 1.56 of 4 pts Question Help Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming...

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

  • REQUIRMENT 1 AND 2 IS SOLVED. PLEASE SOLVE REQUIREMENT 3,4,5 AND 6. region, and the company...

    REQUIRMENT 1 AND 2 IS SOLVED. PLEASE SOLVE REQUIREMENT 3,4,5 AND 6. region, and the company as a WHIC. 2. As the Manitoba region manager, would you investigate the Winnipeg SIO this report? Why or why not? 3. Briefly discuss the benefits of budgeting. Base your discussion on Winnie's World's perfor- mance report. P9-64A Prepare an inventory purchases, and cost of goods sold budget (Learning Objective sy University Logos buys logo-imprinted merchandise and then sells it to university bookstores Sales...

  • CC241 Uses of Accounting Info ll - Online/Course - Smr 3 2020 Afnan Aluwaill & 07/31/20...

    CC241 Uses of Accounting Info ll - Online/Course - Smr 3 2020 Afnan Aluwaill & 07/31/20 2:56 AM Save HW Score: 93.99%, 8.46 of 9 pts Homework: Chapter 9 Homework (required) bore: 0.46 of 1 pt 9 of 99 complete BP9-57A (similar to) Derry Manufacturing is preparing is master budget for the first quarter of the upcoming year. The following dito pertanto Derry Man's persone (Click the icon to view the data) Read the requirements More Info Question Help Requirement...

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

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

  • a. Prepare a schedule of monthly cash receipts for January, February, and March.    b. Prepare...

    a. Prepare a schedule of monthly cash receipts for January, February, and March.    b. Prepare a schedule of monthly cash payments for January, February, and March. c. Prepare a monthly cash budget with borrowings and repayments for January, February, and March. (Negative amounts should be indicated by a minus sign. Assume the January beginning loan balance is $0.) Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to...

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
Active Questions
ADVERTISEMENT