Assume you are starting a new business involving the manufacture and sale of a new product. Raw materials costs are $50 per product. Direct labor costs are expected to be $30 per product. You expect to sell each product for $115. You plan to produce 100 products next month and expect to sell 90 products. A. Prepare cost of production, cost of goods sold, and inventories schedules for the first month. (Cells highlighted in yellow) B. During the second month, you plan to produce 120 products but expect sales in the month to be 115 products. Prepare cost of production, cost of goods sold, and inventories schedules for the second month (Cells highlighted in green)
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
![Assume you are starting a new business involving the manufacture and sale of a new product. Raw
materials costs are $50 per product. Direct labor costs are expected to be $30 per product. You
expect to sell each product for $115. You plan to produce 100 products next month and expect to
sell 90 products.
A. Prepare cost of production, cost of goods sold, and inventories schedules for the first
month (Cells highlighted in yellow)
B. During the second month, you plan to produce 120 products but expect sales in the month to be
115 products. Prepare cost of production, cost of goods sold, and inventories schedules for the
second month (Cells highlighted in green)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F01d01b29-ede7-42ba-8dcd-8c0b18e94cc8%2F06b7a46d-0533-458d-9d55-f477d8d02f4c%2Fomd9b3k_processed.jpeg&w=3840&q=75)
![Cost of Production Schedule:
Production (# units)
Production costs:
Raw materials
Direct labor
Total costs
Cost of Goods Sold Schedule:
Sales (units)
Costs @ $80 per unit
Inventories Schedule:
Cost Per Unit
Beginning finished goods
Production:
Raw materials
Direct labor
Additions (sum of raw materials and direct
labor)
Total (beginning finished goods +
additions)
Less: Cost of goods sold
Ending finished goods
Month 1
Month 1
Month 1
Month 2
Month 2
Month 2](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F01d01b29-ede7-42ba-8dcd-8c0b18e94cc8%2F06b7a46d-0533-458d-9d55-f477d8d02f4c%2Fhkj4shk_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 5 steps with 6 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
![Essentials of Business Analytics (MindTap Course …](https://www.bartleby.com/isbn_cover_images/9781305627734/9781305627734_smallCoverImage.gif)