Determine the optimal monthly production of each wax

Assignment Help Financial Accounting
Reference no: EM13486701

Melnick Enterprises manufactures two products, boat wax and car wax, in two departments, the Mixing Department and the Packaging Department. The Mixing Department has 800 production hours per month available, and the Packaging Department has 1,200 hours per month available. Production of the two products cannot exceed 36,000 pounds. Data on the two products follow/;

 

919_table.png

 

Required:

Use Excel to calculate the optimal monthly production mix (per 100 pounds) of Boat Wax and Car Wax that Melnick should produce?  Clearly show the objective function and the mixing constraints for the linear program that Melnick would use to determine the optimal monthly production of each wax.

Reference no: EM13486701

Questions Cloud

What is the ratio of their angular momentum : A solid sphere and a solid disk of the same mass and radius are rolling wihtout slipping at the same speed. What is the ratio of their angular momentum
Find last ant to fall off the rod : Find last ant to fall off the rod - Output a single integer which is the index (lower index in case two ants are falling simultaneously in the end) of the last ant to fall off.
Explain weak acid and its conjugate base : A buffer contains equal amounts of a weak acid and its conjugate base and has a pH of 5.25. Which of the following values would be reasonable to expect for the pH after addition of a small amount of HCl
Find the rotational kinetic energy about its center of mass : A cylinder of mass 14.0 kg rolls without slipping on a horizontal surface. find the rotational kinetic energy about its center of mass
Determine the optimal monthly production of each wax : Clearly show the objective function and the mixing constraints for the linear program that Melnick would use to determine the optimal monthly production of each wax.
Explain a buffer contains equal amounts of a weak acid : A buffer contains equal amounts of a weak acid and its conjugate base and has a pH of 5.25. Which of the following values would be reasonable to expect for the pH after addition of a small amount of HCl. The answer: 5.15
Rationale for and against policy : Rationale for and against policy
Discover the basic concept of electronic rectifiers : Discover the basic concept of electronic rectifiers and build up the basic skill of electronic fault-finding and electronic design. You understand the applications of rectifiers design.
Explain what is the concentration of ha2 : Consider a solution that is 0.10 M in a weak triprotic acid that is represented by the general formula H3A with the following ionization constants. What is the concentration of HA2-? For H3A Ka1=1.0E-3 Ka2= 1.0E-8 Ka3= 1.0E-12

Reviews

Write a Review

Financial Accounting Questions & Answers

  What should company report as its deferred income tax

What should company report as its deferred income tax liability as of the end of its first year of operations.

  Prepare journal entries to record the transactions on april

On August 1, 2010, Pavlova purchased a piece of replacement property for cash. The new land cost $90,000, and the new building cost $380,000. Prepare journal entries to record the transactions on April 1 and August 1, 2010.

  Compare the two machines and state basis of your compare

Compare the two machines and state the basis of your comparison. Include a cash flow diagram for each alternative. Assume all interest rates at 6% per year unless otherwise stated.

  Prepare an analysis to determine whether varto should sell

Should the company continue to manufacture the part, or should it buy the part from the outside supplier- Target cost equals selling price required return of computer company required return to Timberland - Prepare a three-column comparative income s..

  What factors should be considered

A concerned citizen provides resources and establishes a trust with the local government. What factors should be considered in determining which fund to report the trust activities?

  Income statement preparation using contribution

Income statement preparation using contribution and Absorption Costing - Prepare two income statements, one using the contribution approach and one using the absorption approach.

  Indirect costs are expected to remain the similar

Specialty spark plugs are selling for an average price of $20 and are expected to cost $8 to manufacture with the new equipment. Indirect costs are expected to remain the similar.

  Manual practice set refer to the feedback sheet attached to

refer to the feedback sheet attached to see where marks could be lost. you are not required to complete the

  Multiple choice question on fundamentals of

multiple choice question on fundamentals of accounting.1.nbspall of the following are intangible assets

  Prepare a statement of net assets

Prepare a Statement of Changes in Net Assets for the Employees Retirement Fund for the Year Ended June 30, 2012 and prepare a Statement of Net Assets for the Employees' Retirement Fund as of June 30, 2012.

  Do the benefits of sox justify costs

You have to prepare a 5-page cost/benefit analysis of the Sarbanes-Oxley Act. The focus of the paper should answer the subsequent

  Operating effectiveness of controls related to misstatement

The portfolio, which consisted of traded securities, had increased in market value by $5 million. Materiality for the audit was $10 million.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd