Question
Questions are below in bold. Please do not copy answers from other Determining the Optimal Product Mix with One Constrained Resource Comfy Fit Company manufactures
Questions are below in bold. Please do not copy answers from other
Determining the Optimal Product Mix with One Constrained Resource
Comfy Fit Company manufactures two types of university sweatshirts, the Swoop and the Rufus, with unit contribution margins of $8 and $20, respectively. Regardless of type, each sweatshirt must be fed through a stitching machine to affix the appropriate university logo. The firm leases seven machines that each provides 1,500 hours of machine time per year. Each Swoop sweatshirt requires 9 minutes of machine time, and each Rufus sweatshirt requires 24 minutes of machine time.
Assume that there are no other constraints.
This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.
Determining the Optimal Product Mix with One Constrained Resource | |||
Comfy Fit Company manufactures two types of university sweatshirts and information regarding the two sweatshirts are below. | |||
DATA | |||
Swoop | Rufus | ||
Unit contribution margins | $8 | $20 | |
Minutes of machine time required to affix the logo | 9 | 24 | |
Regardless of type, each sweatshirt must be fed through a stitching machine to affix the appropriate university logo. | |||
Number of machines leased by the company | 7 | ||
Number of hours each machine can operate per year | 1,500 | ||
Number of minutes per hour | 60 | ||
Using formulas and cell references, perform the required analysis, and input your answers into the Amount column. If no entry is required, enter =0. Transfer the numeric results for the green entry cells (B19:B20, B22:B23, B25) into the appropriate fields in CNOWv2 for grading. |
Required: Answers these questions
1. | What is the contribution margin per hour of machine time for each type of sweatshirt? Do not round intermediate calculations. Round your answers to the nearest cent. | ||
Contribution Margin | |||
Swoop | $ | ||
Rufus | $ | ||
2. | What is the optimal mix of sweatshirts? Do not round intermediate calculations. Round your answers to the nearest whole number. If an amount is zero, enter "0". | ||
Optimal Mix | |||
Swoop | units | ||
Rufus | units | ||
3. | What is the total contribution margin earned for the optimal mix? Do not round intermediate calculations. Round your answer to the nearest dollar. | ||
$fill in the blank 6 |
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