Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Wyndor Corporation is in the business of manufacturing windows and doors. They have identified unused capacity in three of their manufacturing plants that they

The Wyndor Corporation is in the business of manufacturing windows and doors. They have identified unused capacity in three of their manufacturing plants that they would like to take advantage of through the introduction of two new products: an eight-foot aluminum storm door and a three-foot by two-foot wooden double-hung window. Their only objective in doing so is to increase profits from the business as much as possible. Their accounting department has estimated that the gross margin of selling doors is $4,500 per unit and the gross margin for selling windows is $6,000 per unit. The company can make as many as they wish with these returns. Each door requires one unit of capacity from the Aluminum Frames Plant and three units of capacity from the Glass and Assembly Plant. Each window requires two units of capacity from the Wood Frames plant and two units of capacity from the Glass and Assembly Plant. The Aluminum Frames plant currently has five units of available capacity, Wood Frames has fourteen units and Glass and Assembly has twenty units.

2a. Set up the problem in Excel and use Solver to determine the number of units of doors and windows the company will produce. (5 pts)

b. What is the capacity used at each plant based on your answer in Question 4? (2 pts)

c. What is the profit based on your answer in Question 4? (3 pts)

d. Solve the problem again, this time assuming the net returns from doors will change to (i) $3,000, (ii) $7,000 and (iii)$10,000. Summarize and report what you observe about each of these solutions as compared to your answer in Q4 where the doors earned $4,500. Why did you observe these changes in activity levels, profit levels and plant utilization? (5 pts)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investments Analysis And Management

Authors: Charles Jones, Nick Jones

11th Edition

0470477121, 9780470477120

More Books

Students also viewed these Finance questions