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

Opportunity Costs, Comparative if Person can make 15 wristbands and hour an...

Comparative if Person can make 15 wristbands and hour and 3 potholders. What is the comparative advantage? If same person works 20 hours a week graph the possible combinations sh

Fiscal policies, All of the following fiscal policies will contribute to in...

All of the following fiscal policies will contribute to increasing budget deficits except: A. cuts in aid to farmers. B. tax cuts. C. increases in defense expenditures. D. increase

Difference between project proposal and project feasibility , Project feasi...

Project feasibility study is needed to make a decision whether the project proposal is technically and economically possible. After finalization of the project feasibility report b

Consumer surplus and producer surplus, Suppose the inverse demand curve for...

Suppose the inverse demand curve for a market is equal to p = 100 -- 0.3Q. The inverse market supply curve is p = 20 + 0.5Q. 1. Calculate the equilibrium price and quantity;

Indifference curve., what is lemda in marginal utility. And how does it af...

what is lemda in marginal utility. And how does it affect the consumption

calculate the npv and pricing models, Burwood Mining is raising capital ...

Burwood Mining is raising capital of $500,000 for its next project from the following sources: Sources Amount $ Common stock 100,000

What are the contents in the market strikes back, What are the contents in ...

What are the contents in the market strikes back? a. Price controls • Price ceiling • Price floor b. Quantity controls quota c. Excise tax d. Inefficiency

Accredited similar dental offices, Should dental offices be accredited simi...

Should dental offices be accredited similar to the standards that hospitals are?

Types of market, #five differnces between a monopoly market and a monopolis...

#five differnces between a monopoly market and a monopolistic market

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