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

A linear programming computer package is needed. EZ-Windows, Inc., manufactures replacement windows for the home remodeling business. In January, the company produced 15,000 windows and ended the month with 9,000 windows in inventory. EZ-Windows' management team would like to develop a production schedule for the next three months. A smooth production schedule is obviously desirable because it maintains the current workforce and provides a similar month-to-month operation. However, given the sales forecasts, the production capacities, and the storage capabilities as shown, the management team does not think a smooth production schedule with the same production quantity each month possible. February March April Sales forecast 15,000 16,500 20,000 Production capacity 14,000 14,000 18,000 Storage capacity 6,000 6,000 6,000 The company's cost accounting department estimates that increasing production by one window from one month to the next will increase total costs by $1.00…
Develop a chase aggregate plan for Draper using apermanent workforce of 12 employees supplemented by overtime.All demand must be met each period.(a) Show what would happen if this plan were implemented.(b) Calculate the costs associated with this plan.(c) Evaluate the plan in terms of cost, customer service,operations, and human resources.
22.7-3
Use the graph to answer the following question: INV B - o A C ROP TIME
Some firms pool overhead into a single plantwide overhead pool, while others accumulate overheadcosts into manufacturing departments, each of which has an overhead cost pool and overhead costapplication rate. Which approach is likely to provide more accurate cost numbers for cost estimating,pricing, and performance evaluation?
Alocal toy manufacturer is using a production line that runs 8 hours per day and produces a toy that requires a total of 7 tasks to be performed. The daily demand is 100 toys. Times of the tasks are 2.73, 2.01, 2.13, 2.0, 2.61, 2.71, and 2.95 minutes for A, B, C, D, E, F, and G, respectively. However, due to the nature of the product there are precedence rules that must be observed. Such that Task A does not need any predecessors; task B requires task A to be completed. To start task C and task D, each require task B to be completed. Task C must be completed prior to stating task E. Task Fneeds both task D and task E to be completed. Finally, task G can start only once task Fis completed. Given we apply the most remaining tasks rule for balancing the assembly line, with ties broken according to longest task time first, the tasks that will be assigned to the FIRST workstation are O a. A and B O b. None is the correct answer c. A only O d. A. B, and C О е. Вonly
Please dont give answer in image format . Do type the answer !
Explain and discuss production examples of overcapacity and under capacity ?
How may ROI be maximised with the use of a balanced scorecard?
The table gives the total cost schedule for oil changes at the local Jiffy Lube. What is Jiffy Lube's total fixed cost?
List five asset accounts, three liability accounts, and five expenseaccounts included in the acquisition and payment cycle for a typical manufacturing company.
Briefly discuss the managerial significance of aggregate planning with reference to capital investment.