Practical Management Science
Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
Bartleby Related Questions Icon

Related questions

Question

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 Spreadsheet

This 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.
expand button
Transcribed Image Text:### Production and Cost Analysis Spreadsheet This 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  |         |          |       |       |     |      |      |        |           |         |          |          |
expand button
Transcribed Image Text:**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 | | | | | | | | | | | | |
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Operations Management
Operations Management
ISBN:9781259667473
Author:William J Stevenson
Publisher:McGraw-Hill Education
Text book image
Operations and Supply Chain Management (Mcgraw-hi...
Operations Management
ISBN:9781259666100
Author:F. Robert Jacobs, Richard B Chase
Publisher:McGraw-Hill Education
Text book image
Business in Action
Operations Management
ISBN:9780135198100
Author:BOVEE
Publisher:PEARSON CO
Text book image
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Text book image
Production and Operations Analysis, Seventh Editi...
Operations Management
ISBN:9781478623069
Author:Steven Nahmias, Tava Lennon Olsen
Publisher:Waveland Press, Inc.