Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Prepare the projected income statement by referring to the amounts: Production Budget Tops Dresses Sweaters Apparels Swimwear Accessories Jeans Forecasted Unit Sales 2500 2200 1500
Prepare the projected income statement by referring to the amounts:
Production Budget | |||||||
Tops | Dresses | Sweaters | Apparels | Swimwear | Accessories | Jeans | |
Forecasted Unit Sales | 2500 | 2200 | 1500 | 1500 | 1200 | 1000 | 840 |
Add: Planned Finished Goods Ending Inventory (5 % of Forecasted Sales) | 125 | 110 | 75 | 75 | 60 | 50 | 42 |
Less: Beginning Finished Goods Inventory (10% of last year's forecasted sales) | 240 | 210 | 140 | 140 | 110 | 90 | 84 |
Required Units to be Produced | 2385 | 2100 | 1435 | 1435 | 1150 | 960 | 798 |
Sales budget for the year
Clothing | units | per unit price | total sales | cost per unit | total cost | Gross profit |
Jeans | 840 | 81 | 68040 | 27 | 22680 | 45360 |
Tops | 2500 | 60 | 150000 | 20 | 50000 | 100000 |
Dresses | 2200 | 90 | 198000 | 30 | 66000 | 132000 |
Sweaters | 1500 | 108 | 162000 | 36 | 54000 | 108000 |
Apparel | 1500 | 240 | 360000 | 80 | 120000 | 240000 |
Swimwear | 1200 | 120 | 144000 | 40 | 48000 | 96000 |
Accessories | 1000 | 150 | 150000 | 50 | 50000 | 100000 |
Total | 123240 | 410680 | 821360 |
Operating expense budget for the next year:
Particulars | Amount($) |
Office salaries | 166950 |
Office supplies | 12000 |
Sales salaries | 253050 |
Communication expense | 17250 |
Depreciation expense | 54900 |
Rent expense | 60000 |
Utilities expense | 82800 |
Bank charges | 6050 |
Miscellaneous expense | 19887.5 |
Total | 672887.5 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started