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

Effects of fiscal policy, (Effects of Fiscal Policy) Recently some legislat...

(Effects of Fiscal Policy) Recently some legislators have called for tax increases to reduce the federal budget deficit. Conservatives have countered that such tax increases could

Calculate the npv for discount rates, Shambles, a large toy retailer, are l...

Shambles, a large toy retailer, are looking at bringing out a new range of soft toys. The range under consideration is "Mythical Beasts."  The "Mythical Beasts" range will cost £50

What do you mean by exchange rate, Q. What do you mean by Exchange rate? ...

Q. What do you mean by Exchange rate? Exchange rate is defined as the price of one unit of currency in terms of another currency. If one euro costs 1.5 USD then 1 USD costs 1/1

For product price elasticity of demand, You are the manager of a firm that ...

You are the manager of a firm that receives revenues of $50,000 per year from product X and $80,000 per year from product Y. The own price elasticity of demand for product X is -3,

Inftaion, what is the cause of inflation in PNG

what is the cause of inflation in PNG

Demand for memberships at the health club, a health club sells 50 membershi...

a health club sells 50 memberships when the monthly price is $60 and 70 memberships when the monthly price is $40. the price elasticity of demand for memberships at this health clu

Manager of a firm, You are the manager of a firm that receives revenues of ...

You are the manager of a firm that receives revenues of $40,000 per year from product X and $90,000 per year from product Y. The own price elasticity of demand for product X is -1.

What is the price elasticity of demand, Consider the following utility func...

Consider the following utility function: U = X 1 X 2 Where X 1 and X 2 are quantities consumed of two goods. You are considering the actions of a consumer that maxi

Equilibrium analysis, A vital question is whether the equilibrium we have i...

A vital question is whether the equilibrium we have identified in labor market (with a high unemployment rate) can remain in long run. Will there not be adjustments which will take

Control of ochratoxin, Q. Control of ochratoxin? Control: Once ochratox...

Q. Control of ochratoxin? Control: Once ochratoxin A has been formed in a food, it is difficult to remove by most forms of food processing. Cooking with or without previous soa

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