Water Play, Inc. Part 2-Constant Demand and Seasonal Budgets 1. The company has decided they needed to create a full set of budget schedules including financial statements for the first year of operations based on an assumption of constant demand of 18,000 quarterly and 72,000 for the first year (appendices B-1 through B-11). A second set of budget schedules and financial statements based on expected unit sales of 15,000 in quarter one, 25,000 in quarter two, 20,000 in quarter three, and finally 12,000 in quarter four for a total of 72,000 for the year based on a seasonal demand pattern (appendices C-1 through C-11). We expect the same quarterly sales patterns in year two meaning 18,000 units per quarter under constant demand and 15,000 units in quarter one under seasonal demand. Compare the constant demand to the seasonal demand budget. Explain the major differences in each of the budget schedules, cash budget and financial statements on both a quarterly and annual basis. Remember the beginning and ending raw material and finished goods inventory units will cause differences in the budgets but also focus on the differences between accrual and cash timing figures.\fAppendix C-3 Water Play, Inc. Production Budget-Part 2 January 1, 20XX Desired Ending FG 10% Annual Year 2 Q1 Q2 03 04 Total Q1 02 Sales Units 15,000 25,000 20,000 12,000 72,000 15,000 25,000 Desired Ending FG units 2,500 2,000 1,200 1,500 1,500 2,500 Total Units Needed 17,500 27,000 21,200 13,500 73,500 17,500 Less Beginning FG units 1,500 2,500 2,000 1,200 1,500 1,500 Units to be Produced 16,000 24,500 19,200 12,300 72,000 16,000Appendix B-4 Water Play, Inc. Cash paid in quarter of purchase 63.0% Materials Budget--Part 2 Cash paid the following quarter 37.0% January 1, 20XX Annual Year 2 01 Q2 Q3 04 Total Q1 Units to be Produced 18,000 18,000 18,000 18,000 72,000 18,000 Direct Material Cost/unit $ 7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 Total Direct Material Cost 135,000,000 135,000,000 135,000,000 135,000,000 540,000,000 135,000,000 Desired Ending Inventory (10%) 13,500,000 13,500,000 13,500,000 13,500,000 13,500,000 Direct Material Cost Needed 148,500,000 148,500,000 148,500,000 148,500,000 553,500,000 Less Beginning Inventory 13,500,000 13,500,000 13,500,000 13,500,000 13,500,000 Direct Material Purchases 135,000,000 135,000,000 135,000,000 135,000,000 540,000,000 Cash Disbursements Schedule Beginning A/P balance 0 Q1 payment of Q1 purchases 85,050,000 85,050,000 Q2 payment of Q1 purchases 49,950,000 49,950,000 Q2 payment of Q2 purchases 85,050,000 85,050,000 Q3 payment of Q2 purchases 49,950,000 49,950,000 Q3 payment of Q3 purchases 85,050,000 85,050,000 Q4 payment of Q3 purchases 49,950,000 49,950,000 Q4 payment of Q4 purchases 85,050,000 85,050,000 Total Payments by Quarter 85,050,000 135,000,000 135,000,000 135,000,000 490,050,000 Ending A/P Balance 49,950,000Appendix C-4 Water Play, Inc. Cash collected quarter of sale 63.0% Materials Budget--Part 2 Cash collected following quarter 37.0% January 1, 20XX Annual Year 2 Q1 Q2 Q3 Q4 Tota Q1 Units to be Produced 16,000 24,500 19,200 12,300 72,000 16,000 Direct Material Cost/unit 7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 Total Direct Material Cost 120,000,000 183,750,000 144,000,000 92,250,000 540,000,000 120,000,000 Desired Ending Inventory (10%) 18,375,000 14,400,000 9,225,000 12,000,000 12,000,000 Direct Material Cost Needed 138,375,000 198,150,000 153,225,000 104,250,000 552,000,000 Less Beginning Inventory 12,000,000 18,375,000 14,400,000 9,225,000 12,000,000 Direct Material Purchases 126,375,000 179,775,000 138,825,000 95,025,000 540,000,000 Cash Disbursements Schedule Beginning A/P balance 0 Q1 payment of Q1 purchases 79,616,250 79,616,250 Q2 payment of Q1 purchases 46, 758,750 46,758,750 Q2 payment of Q2 purchases 113,258,250 113,258,250 Q3 payment of Q2 purchases 66,516,750 66,516,750 Q3 payment of Q3 purchases 87,459,750 87,459,750 Q4 payment of Q3 purchases 51,365,250 51,365,250 Q4 payment of Q4 purchases 59,865,750 59,865,750 Total Payments by Quarter 79,616,250 0,017,000 153,976,500 111,231,000 504,840,750 Ending A/P Balance 35,159,250Appendix B-5 Water Play, Inc. Direct Labor Budget--Part 2 January 1, 20XX Annual Year 2 Q1 Q2 Q3 Q4 Total Q1 Units to be Produced 18,000 18,000 18,000 18,000 72,000 18,000 X Direct Labor Hours/unit 90 90 90 90 90 90 Total DLHs for units produced 1,620,000 1,620,000 1,620,000 1,620,000 6,480,000 1,620,000 X Average Hourly Labor Rate $32.10 $32.10 $32.10 $32.10 $32.10 $32.10 Total Direct Labor Cost 52,002,000 52,002,000 52,002,000 52,002,000 208,008,000 52,002,000- Water Play, Inc. Direct Labor Budget-$311 2 - Annual Year 2 nn-m---- X Direct Labor Hours/unit 90 90 90 90 90 90 Total DLHs for units produced 1,440,000 2,205,000 1,723,000 1,107,000 6,430,000 1,440,000 x Average Hourly Labor Rate $32.10 $32.10 $32.10 $32.10 $32.10 $32.10 - Total Direct Labor Cost 46,224,000 70,730,500 55,463,300 35,534,700 203,003,000 46,224,000