Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Mikes bike shop has asked you to prepare a sales budget and production budget for the first quarter of the year using the following information:
- Mikes bike shop has asked you to prepare a sales budget and production budget for the first quarter of the year using the following information:
- Selling price of custom bike: $800
- Expecting to sell 200 bikes in January and a 10% increase in each month for the next 6 months
- The required ending inventory is 20% of next months sales.
Sales Budget
For the Quarter Ended March 31, 2021
| January | February | March | Total |
Expected Sales (Units) |
|
|
|
|
Selling Price per Bike |
|
|
|
|
Total Sales Revenue |
|
|
|
|
Production budget using same information
| January | February | March |
Expected Sales (Units) |
|
|
|
Desired Ending Inventory (Units) |
|
|
|
Total Required Units |
|
|
|
Less: Beginning Inventory |
|
|
|
Required Production |
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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