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

Analyse Inflation, 1. how long will take to deliver a 3000-word assignmen. ...

1. how long will take to deliver a 3000-word assignmen. Must include reliable references.deadline 2nd sept 2. How much do you guys charge? Can I avail the 50% offer?Minimum 100 wo

Aggregate demand and aggregate supply, Find one or more articles in the wal...

Find one or more articles in the wall street Journal or other business publications that describe changes in fiscal or monetary policies in the United States. Discuss how these pol

Obtain a histogram of systolic blood pressure, The data set lowbwt.sav co...

The data set lowbwt.sav contains information for a sample of 100 low birth weight infants born in two teaching hospitals in Boston. Measurements of systolic blood pressure are sa

Econ, Christina Romer and Jared Bernstein in "The Job Impact of the America...

Christina Romer and Jared Bernstein in "The Job Impact of the American Recovery and Reinvestment Plan" calibrated the impact of the proposed expansionary fiscal policy (we know it

Define the fisher equation, Define the Fisher equation Fisher equation ...

Define the Fisher equation Fisher equation is: Money supply (stock of money) x velocity of circulation of money = price level x total transactions in the economy or     MV =

Inflation, inflation of fuel price on consumer

inflation of fuel price on consumer

About assignment, i have assignment due within less than 24 hours if i sub...

i have assignment due within less than 24 hours if i submit assignment can i get it back before 24 hours?

Wonderland department of commerce, In 2010, Wonderlanders consumed 15 milli...

In 2010, Wonderlanders consumed 15 million liters of rum at an average price of $5 per liter. The Wonderland department of commerce has estimated that the price elasticity of the d

Calculate the cross price elasticity, Syesha loves to eat Sunday breakfast ...

Syesha loves to eat Sunday breakfast at her local Scrambles restaurant. She usually orders a la carte. Her usual breakfast consists of 2 scrambled eggs, 1 piece of bacon and 2 link

Explain the problem involved in consumer price index, Q. Explain the proble...

Q. Explain the problem involved in consumer price Index? To explain the problems involved in calculating CPI we consider MP3 players. If you measure the average price of MP3 pl

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