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 in addition to the direct effect on dairy prices, Subsidy programs ...

Subsidy programs are likely to have a number of secondary effects in addition to the direct effect on dairy prices. What impact do you suppose farm subsidies are likely to have on

Industry''s long-run supply schedule, A perfectly competitive painted neckt...

A perfectly competitive painted necktie industry has a large number of potential entrants. Each firm has an identical cost structure such that long-run average cost is minimized at

Cost curves, the difference between the AC and the AVC curve

the difference between the AC and the AVC curve

Describe the short run effect of the supply shock, Question : The long-...

Question : The long-run position of an economy is described by the quantity theory of money: M/P = L (Y, r) Where M: nominal money stock; P: price level; Y: real income a

Firm''s total revenues, How much will your firm's total revenues (revenues ...

How much will your firm's total revenues (revenues from both products) change if you increase the price of good X by 2 percent?

Clasical model., if we impose any rule and regulation on clasical model lik...

if we impose any rule and regulation on clasical model like not expoit polutionso what is effect on factor of clasical model

After your last deposit withdraw immediately, You make a monthly deposit of...

You make a monthly deposit of $1,000 into a saving account for the next 10 years. How much can you withdraw immediately after your last deposit if your saving account pays 6% per y

Calculate the income elasticity and good , Due to the recent downturn in e...

Due to the recent downturn in economic activity, Taz, has seen his hours at work reduced. He used to work 30 hours a week at $13 and hour, but now he works 22 hours. Due to this

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