Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help! thanks (: Water Play, Inc. Part 2 Constant Demand and Seasonal Budgets 1. The company has decided they needed to create a full

image text in transcribed

image text in transcribed

image text in transcribed

Please help! thanks (:

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 acerual and cash timing figures. Appendix B-7 Water Play, Inc. Selling and General Administrative Budget January 1, 20XX 2 Year 2 Q1 18,000 Units sold Vanable SG&A cost / unit Total Variable SG&A cost Total Fixed SG&A cost Total SG&A cost Less: Depreciation Cash SG&A costs Q1 18,000 2,400 43,200,000 90,937,500 134,137,500 1,037,500 133,100,000 Q2 18,000 2,400 43,200,000 90,937,500 134,137,500 1,037,500 133,100,000 Q3 18,000 2,400 43,200,000 90,937,500 134,137,500 1,037,500 133.100,000 04 18,000 2,400 43,200,000 90,937,500 134,137,500 1,037,500 133,100,000 Annual Total 72,000 2,400 172,800,000 363.750,000 536,550,000 4,150,000 532,400,000 Bill Appendix Water Play, Inc. Selling and General Administrative Budget January 1, 20XX Year 2 Q1 15.000 Units sold Variable SG&A cost/unit Total Variable SG&A cost Total Fixed SG&A cost Total SG&A cost Less: Depreciation Cash SG&A costs Q1 15,000 2,400 36,000,000 90,937,500 126,937,500 1,037,500 125,900,000 Q2 25,000 2,400 60,000,000 90,937,500 150,937,500 1,037,500 149.900.000 Q3 20,000 2,400 48,000,000 90,937,500 138,937,500 1,037,500 137,900,000 Q4 12.000 2,400 28.800,000 90,937,500 119,737,500 1,037,500 118.700,000 Annual Total 72,000 2,400 172,800,000 363,750,000 536,550,000 4,150,000 532,400,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Tools For Business Decision Making

Authors: Weygandt, Kimmel, Kieso

4th Edition

0470478535, 978-0470478530

More Books

Students also viewed these Accounting questions

Question

=+b) Would you use this model? Explain.

Answered: 1 week ago

Question

Describe several models for organizing a human resources department

Answered: 1 week ago