Please calculate the correct values for the regular AND overtime production and also calculate net profit, show answers please I have to finish this tonight, thank you! ### Production and Cost Analysis SpreadsheetThis spreadsheet outlines a company's production plan and cost analysis over a one-year period, divided into monthly segments.#### Basic Information:- **Unit Production Cost (Regular):** $305- **Unit Production Cost (Overtime):** $345- **Selling Price per Unit:** $510- **Holding Cost per Month:** $15- **Starting Inventory:** 15 units#### Monthly Production and Sales Data:- **Regular Production:** - **January:** 385 units - **February - March:** 400 units each - **April:** 450 units - **May - July:** 500 units each - **August:** 500 units - **September - December:** 400 units each- **Overtime Production:** - **July:** 75 units - **August:** 75 units - Other months have zero overtime production.- **Forecasted Sales:** - **January - April:** 400 units each - **May - July:** 600 units each - **August:** 600 units - **September - December:** 400 units each#### Analysis:- **Regular Production** ranges from a low of 385 units in January to a peak of 500 units from May through August.- **Overtime Production** is minimal, occurring only in July and August, indicating increased demand during these months.- **Forecasted Sales** show higher demand from May to August at 600 units, with the rest of the year steady at 400 units, aligning with overtime production during these peak months.This structured approach helps in planning for production costs, optimizing inventory management, and meeting forecasted sales efficiently while managing production resources effectively. **New Exercise Bank Content Question 07-06**Decorum Incorporated manufactures high-end ceiling fans. Their sales are seasonal with higher demand in the warmer summer months. Typically, sales average 400 units per month. However, in the peak months (June, July, and August), sales spike up to 600 units per month. Decorum can produce up to 500 units per month at a cost of $305 each. By bringing in temporary workers, Decorum can produce up to an additional 75 units at a cost of $345 each. Each ceiling fan sells for $510 each. Decorum can carry inventory from one month to the next, but at a cost of $15 per ceiling fan per month. Decorum has 15 units in inventory at the start of January.[Click here for the Excel Data File]Build and solve a linear programming spreadsheet model to maximize the profit over all 12 months.a. Assuming Decorum must produce enough ceiling fans to meet demand, how many ceiling fans should Decorum produce each month (using their regular labor force and/or temporary workers) over the course of the next year so as to maximize their total profit?b. Determine the net profit.**Complete this question by entering your answers in the tabs below.**- **Required A**- **Required B****Assuming Decorum must produce enough ceiling fans to meet demand, how many ceiling fans should Decorum produce each month (using their regular labor force and/or temporary workers) over the course of the next year so as to maximize their total profit?***Note: Leave no cells blank. Enter zero (0) whenever required.*| | January | February | March | April | May | June | July | August | September | October | November | December ||-----------|---------|----------|-------|-------|-----|------|------|--------|-----------|---------|----------|----------|| Regular production | | | | | | | | | | | | || Overtime production | | | | | | | | | | | | |

Aggregate planning is a marketing activity that does an aggregate plan for the production process,…

Decorum Incorporated manufactures high-end ceiling fans. Their sales are seasonal with higher demand in the warmer summer months. Typically, sales average 400 units per month. However, in the hot summer months (June, July, and August), sales spike up to 600 units per month. Decorum can produce up to 500 units per month at a cost of $305 each. By bringing in temporary workers, Decorum can produce up to an additional 75 units at a cost of $345 each. Decorum sells the ceiling fans for $510 each. Decorum can carry inventory from one month to the next, but at a cost of $15 per ceiling fan per month. Decorum has 15 units in inventory at the start of January.

Decorum Incorporated manufactures high-end ceiling fans. Their sales are seasonal with higher demand in the warmer summer months. Typically, sales average 400 units per month. However, in the hot summer months (June, July, and August), sales spike up to 600 units per month. Decorum can produce up to 500 units per month at a cost of $305 each. By bringing in temporary workers, Decorum can produce up to an additional 75 units at a cost of $345 each. Decorum sells the ceiling fans for $510 each. Decorum can carry inventory from one month to the next, but at a cost of $15 per ceiling fan per month. Decorum has 15 units in inventory at the start of January.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Calculate the turnover for the Fall season if the sales are planned at $215,800 and the average inventory is $189,180.
Your small toy manufacturing facility has the following information: Fixed costs $39,000 Material cost per toy $0.888 Electricity cost per toy $0.044 Labor cost per toy $0.207 Management demands that we have $9,000 in profit if we sell 45,000 toys. What must the selling price be to achieve this? (Enter three decimal places)
c6 need urgent in 15 minutes
The table below provides the aggregate plan of production by a firm. It is known that the firm uses a chase plan. The firm’s labor cost is $10/unit, hiring cost is $200 per unit of increase, and unit firing cost is $400 per unit of decrease in production. Given this information, what is the number in the cell with the question mark?
True or False: Capacity planning in operations management involves ensuring that a company's resources, including equipment, labor, and facilities, are able to meet current and future demand levels efficiently.
Pls help with this homework.
ABC Inn has 2 departments: rooms and F&B. the rooms department has a CMR of 0.6 and the F&B department has a CMR of 0.4 the rooms department take in 70% of total revenue and the F&B department takes in 30% of total revenue. If the combined total monthly fixed costs for the entire hotel are equal to $100,00. What is the break-even level of sales?
Deforrest Marine Motors manufactures engines for the speedboat racing circuit. As part of their annual planning cycle, they forecasted demand for the next four quarters. The number of available days of production and the anticipated demand are given below. Employees Production Rate Production Cost Backorder Cost Overtime Cost Overtime Limit Demand Q1 2,400 6,019,000 They also estimated many of the costs required to conduct operations planning. Some of these key figures are listed below. 30 70 units/employee/quarter Q2 2,200 $1,000/unit $200/unit/quarter $1,500/unit <= 25% of Reg. Production Q3 1,700 Q4 1,800 Hire Cost Fire Cost Subcontracting Cost Subcontracting Limit Inventory Cost Initial Inventory $1,200/employee $800/employee $1,800/unit 400 units maximum $100/unit/quarter 280 units Deforrest Marine Motors wishes to maintain the current number of employees for the entire year to follow a level strategy balanced with inventory and backorders as needed. What is the total cost of this…
If property management have to go the resident home for checking what possible problem does the property management will face and how to due with ? i hope you can ans me thank you
Why is there a need for aggregate planning? please help me, the answer must be clear and need typed answer. please dont copy.
kate Joseph is a new staff accountant at kaufman and associates. she is paid a salary of 63,800 per year and is expected to work 2,200 hours per hours per year on client jobs. The firm's indirect cost allocation rate is $25 per hour. The firm would like to acheive a profit of equal to 15% of cost.