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

Corresponding future value, Calculate the present value P at time zero and ...

Calculate the present value P at time zero and the corresponding future value F at the end of year three for a series of $15,000 payments to be made at the end of each of years one

Solution, the classical model assumes that consumption depends positively o...

the classical model assumes that consumption depends positively on disposable income. now suppose that consumption also depends on the real interest rate. a) sketch the loanable

What is net present worth for new computer system, Kermit is considering pu...

Kermit is considering purchasing a new computer system. The purchase price is $106,430. Kermit will borrow one-fourth of the purchase price from a bank at 10 percent per year compo

Controlling the supply of money, When the reserve requirement changes, whic...

When the reserve requirement changes, which of the following will change in the total banking system?  (Answer change or No Change) Transaction Deposits Total Reserves Req

Pseudoreplication, Give your own example of "pseudoreplication" (sensu Hurl...

Give your own example of "pseudoreplication" (sensu Hurlbert 1984) in an experiment. How does pseudoreplication cause problems for correct inferences from experiments?

Gdp price index, Determine the GDP price index for 1984, using 2005 as the ...

Determine the GDP price index for 1984, using 2005 as the base year

Give example of commercial banks how they create money, Give example of com...

Give example of commercial banks how they create money For example, the borrower uses the money to buy an apartment, the funds are transferred to the seller of the apartment. T

What is keynesian model, Q. What is Keynesian model? Keynesian model is...

Q. What is Keynesian model? Keynesian model is slightly more complicated than the classic model and it is developed in four stages by analysing four separate models. Every mode

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

Philip curve, why social faces inflation and unemployment?

why social faces inflation and unemployment?

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