Company produce to maximize their weekly profit

Assignment Help Financial Management

Reference no: EM132014518

Bronze Forge Co. produces and ships 3 different plates: cake plates, bread plates, and dinner plates. Each cake plate requires $15 in materials, 5 hours of labor, and $6 to ship. Each bread plate requires $10 in materials, 4 hours of labor, and $5 to ship. Each dinner plate requires $8 in materials, 4 hours of labor, and $5 to ship. The profit on the cake plate is $15, on the bread plate is $12, and on the dinner plate is $5. The company has up to 2700 labor hours available per week. Each week, they can spend at most $1500 on materials and $1200 on shipping. How many plates in each category should the company produce to maximize their weekly profit? (a) Formulate a LP problem to Maximize Z = Weekly profit, subject to the constraints given (b) Solve the above LP problem using Excel-Solver

Reference no: EM132014518

Questions Cloud

Some type of replacement chain analysis : Would the failure to employ some type of replacement chain analysis bias an NPV analysis against one of the projects? Explain.

Concept of the covered interest rate parity imply in case : What current spot exchange rate would the concept of the covered interest rate parity imply in this case?

Cause change in the irr ranking of two such projects : Would changes in the cost of capital ever cause a change in the IRR ranking of two such projects? Why or why not?

Expensive car for your new delivery service : You are trying to pick the least-expensive car for your new delivery service.

Company produce to maximize their weekly profit : How many plates in each category should the company produce to maximize their weekly profit?

The discount rate when analyzing the acquisition of firm : Which of these rates is most appropriate to use as the discount rate when analyzing the acquisition of Firm B by Firm A?

What is the new required return on equity : KarTeX Inc, was recently founded to manufacture a new efficient fuel injection system. What is the new required return on equity?

Cash flows comprise of changes in operating cash flows : The project’s incremental cash flows comprise of changes in operating cash flows, which one:

Percentage change in the value of bond mentioned : What will be the percentage change in the value of the bond mentioned in the previous question if the yield to maturity decreases by 60 basis points?

User Account

All Pages