Question: please help in excel and show formulas pressed weed available for the East-side plant weekly. The aluminum fittings that reinforce the legs of both the

please help in excel and show formulas pressedplease help in excel and show formulas pressedplease help in excel and show formulas pressedplease help in excel and show formulas

pressed weed available for the East-side plant weekly. The aluminum fittings that reinforce the legs of both the tables and chairs are purchased from an outside supplier. Franklin Furniture can purchase up to 400 boxes of fittings weekly; one box is required for each table or chair manufactured. Production time is 72 minutes ( 1.2 hours) per table and 18 minutes ( 0.3 hours) per chair. Franklin Furniture has eight employees, each of whom works an average of 7.5 hours per day. Thus, in an average five-day work week, the company has available 8(7.5)(5)=300 production hours. Franklin Furniture also produces desks and computer workstations at its West-side plant. Each desk nets the company a profit of $100, while each computer workstation nets $125. These products are also produced from finished pressed wood and aluminum. The amount of each, as well as the labor time needed to produce a desk or computer workstation, is given in the following table. Franklin Furniture is considering combining operations of both plants into a single plant. This consolidation will combine the weekly available resources so that 12,000 square feet of pressed wood, 800 boxes of aluminum fittings, and 600 production hours will available weekly. However, the accounting department estimates the cost of renovating the plant will be $5000 per week, on an amortized basis. In your role of a Business Consultant to Franklin Furniture, prepare a business report for Franklin Furniture giving optimal weekly production schedules for each of its plants operating separately. Then include an analysis and recommendation to Franklin Furniture for combining operations at both plants into a single plant. (Hint: This case can be solved by splitting it into three small cases, two of which can be analyzed using only two decision variables.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!