? 1H 7 MASTER BUDGETI Chegg StudylGuided Solut (1) What\'s the for mula for cala

Question

? 1H 7 MASTER BUDGETI Chegg StudylGuided Solut (1) What's the for mula for cala . CPP Signon Bb Courses - Blackboard Learn ? ? O?|Oeztomheducation.com/hm.tpx?--0.9437767902535793-1532315902427 m???? a. What are the total expected cash collections for the year under this revised budget? cash collections for the b. What is the total required production for the year under this revised budget? Total required production for the units C. What is the total cost of raw materials to be purchased for the year under this revised budget? d. What are the total expected cash disbursements for raw materials for the year under this revised budget? Total expe cash disbursements for raw materials e. After seeing this revised budget, the production manager cautioned that due to the current production 8-21 PM O Type here to search ^??dy 7/22/2018

Explanation / Answer

SALES BUDGET Q-1 Q-2 Q-3 Q-4 YEAR Budgeted Sales units 45,000 70,000 105,000 60,000 280,000 Selling price per unit 7 7 7 7 7 Total Sales 315,000 490,000 735,000 420,000 1,960,000 EXPECTED CASH COLLECTIONS Q-1 Q-2 Q-3 Q-4 YEAR Beginning Accounts receivable 65,000 65,000 Quarter-1 Sales 236,250 78750 315,000 Quarter-2 Sales 367500 122500 490,000 Quarter-3 Sales 551,250 183,750 735,000 Quarter-4 Sales 315,000 315,000 Total Cash Collections 301,250 446,250 673,750 498,750 1,920,000 PRODUCTION BUDGET Q-1 Q-2 Q-3 Q-4 YEAR Q1 Yr 3 Q2 Yr 3 Budgeted Sales Units 45,000 70,000 105,000 60,000 280,000 85,000 95,000 Add: Desired Ending Finished inventory 21,000 31,500 18,000 25,500 25,500 28,500 Total Needs 66,000 101,500 123,000 85,500 305,500 113,500 Less: Beginning Finished Inventory 12,000 21,000 31,500 18,000 12,000 25,500 Required Production in units 54,000 80,500 91,500 67,500 293,500 88,000 RAW MATERIAL PURCHASE BUDGET Q-1 Q-2 Q-3 Q-4 YEAR Q1 Yr3 Budgeted Production Units 54,000 80,500 91,500 67,500 293,500 88,000 RM Requirement per unit 5 5 5 5 5 5 Total Raw material required in pounds 270,000 402,500 457,500 337,500 1,467,500 440,000 Add: Desired Ending Inventory 40,250 45,750 33,750 44,000 44,000 Total needs 310,250 448,250 491,250 381,500 1,511,500 Less: Beginning Inventory 23,000 40,250 45,750 33,750 23,000 Budgeted Purchase in units 287,250 408,000 445,500 347,750 1,488,500 Cost per pound 0.80 0.80 0.80 0.80 0.80 Budgeted Purchase in $ 229,800 326,400 356,400 278,200 1,190,800 EXPECTED CASH PAYMENTS Q-1 Q-2 Q-3 Q-4 YEAR Beginning Accounts payable 81,500 81500 Quarter-1 Purchases 137880 91920 229800 Quarter-2 Purchases 195840 130560 326400 Quarter-3 Purchases 213840 142560 356400 Quarter-4 Purchases 166920 166920 Total Cash disbursement 219,380 287,760 344,400 309,480 1,161,020

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.