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

  Question subsequent are examples of control deficiencies

question subsequent are examples of control deficiencies that may represent important deficiencies or material

  Headsmart manufactures headphone casesnbsp during september

headsmart manufactures headphone cases.nbsp during september 2011 the company produced 106000 cases and recorded the

  What is the amount the employer should record as payroll

What is the amount the employer should record as payroll taxes expense for the employee for the month of January?

  What arguments would brian jones manager of the mining

What arguments would brian jones, manager of the mining division, make to support the transfer pricing method that he prefers.

  Prepare the correcting entry necessary when these errors

Prepare the correcting entry necessary when these errors are discovered. Assume that the books for 2011 are closed. (Ignore income tax considerations.) (For multiple debit/credit entries, list amounts from largest to smallest eg 10, 5, 3, 2.)

  What is the new wage and rental price of land

What is the new wage and rental price of land? What share of output does labor receive now?

  Evaluate the company''s unit product costs

Recomputed the company\'s unit product costs in accordance with your recommendations.

  Illustrate what would be recorded as a gain

Sun estimates the fair value of the recourse liability at $150,000. Illustrate what would be recorded as a gain (loss) on the transfer of receivables?

  Adjust the trial balance for the closing entries

Complete the entries to adjust the trial balance for the closing entries and prepare an statement of income and statement of financial position

  Calculate the incremental npv of the lease agreement

Calculate the incremental NPV of the lease agreement and ascertain if the company should take out the lease.

  Question 1pt inc which has been in business since 1980 uses

question 1pt inc. which has been in business since 1980 uses a fiscal year ending june 30. the shareholders recently

  Prepare a journal entries that summarize sales

Prepare a journal entries that summarize sales of the awnings (assume all lcredit sales) and any aspects of the warranty that should be recorded during 2011.

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