Estimate the maximum possible daily profit, Macroeconomics

Assignment Help:

Shambles have selected the "Mythical Beasts" range and decided to concentrate on "Pegasus" and "Phoenix." They would now like to find the right mix of these two products in order to maximise profit. Each toy has to go through two processes during manufacture: sewing and stuffing.

Pegasus takes 30 minutes to sew whilst Phoenix takes 20 minutes; there are 10 hours (600 minutes) available for sewing each day.

Pegasus takes 20 minutes to stuff whilst Phoenix takes 25 minutes; there are 10 hours (600 minutes) available for stuffing each day.

Pegasus generates £4 profit per toy whilst Phoenix generates £5 profit per toy.

What is the maximum possible daily profit, and how many of each product should be produced in order to achieve this?

Use "Solver" in Microsoft Excel to solve this problem. Include:

a print-out of cell values
a print-out of cell formulae
a print-out of the Solver dialogue box with optimisation conditions and constraints
an Answer Report from Solve
a statement of the answer in words

 


Related Discussions:- Estimate the maximum possible daily profit

Equilibrium price and quantity, Say that the equilibrium price and quantity...

Say that the equilibrium price and quantity both rose. What would you say was the most likely cause? There was _____(increase, decrease, no change) in demand and ________(increase,

Deceased relative at zero prices, Kennesaw University Professor Frank A. Ad...

Kennesaw University Professor Frank A. Adams III and Auburn University Professors A. H. Barnett and David L. Kaser man recently estimated the effect of legalizing the sale of cadav

#GDP, #“Nominal GDP declined between 2008 and 2009, therefore the GDP defla...

#“Nominal GDP declined between 2008 and 2009, therefore the GDP deflator must also have declined.”

Determine the value of the goverment expenditure multiplier, Assume that th...

Assume that the economy is characterized by the following structural equations: C = 160 + 0.6 (4 - T) I = 150; G = 150; T = 100. a) Determine the equilibrium output level

.sohkhlet, What do is and LM curve signify?

What do is and LM curve signify?

What are the explicit costs, A young chef is considering opening his own su...

A young chef is considering opening his own sushi bar. to do so, he would have to quite his current job, which pays him $20,000 a year , and take over a store building that he owns

Financial Crises, #question. BANK Z (@ 10% RR) ASS...

#question. BANK Z (@ 10% RR) ASSETS LIABILITIES RR: K200,000 Deposits : K2,000,000 ER : K1,800,000 You are given the above Balance sheet for Bank Z as

Neo-classical synthesis, Neo-classical synthesis is a synthesis of classica...

Neo-classical synthesis is a synthesis of classical model and Keynesian model. In brief, it states that Keynesian model is correct in the short run whereas the classical analysis i

Country club bills, Suppose the country club bills based on a sample of 4 m...

Suppose the country club bills based on a sample of 4 members are: 358, 958, 665, 846. What is the standard deviation for this sample of bills? (please round your answer to 1 decim

Producer equilibrium, If the MPPL/ MPPK in the production of a good are les...

If the MPPL/ MPPK in the production of a good are less than w/r, why is the produce not in producer equilibrium? Explain how, with no change in budget size for the firm and with th

Write Your Message!

Captcha
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