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

Effect which have the bond market, Firms such a Moody's and Standard & Poor...

Firms such a Moody's and Standard & Poor's study corporations that issue bonds. They publish "ratings" for the bonds- evaluation of the likelihood of default. Suppose these rating

Multiple expansion in banking, Multiple Expansion We have seen that a s...

Multiple Expansion We have seen that a single bank in a banking system can lend rupee for rupee with its excess reserves. What is the lending ability of the commercial banking

Balance between automation and labor, Businesses often decide between using...

Businesses often decide between using automation and labor in production. An automotive environment may have high fixed costs and low variable costs, and an industry that utilizes

Determine why banks raise their interest rates, Determine Why banks raise t...

Determine Why banks raise their interest rates A way to explain why banks raise their interest rates is as follows. With higher overnight interest rates, it is more expensive fo

Effect of a large federal deficit on interest rates, Explain, using the bes...

Explain, using the best framework you can think of (based on our class discussion), the effect of a large federal deficit on interest rates.

Citizens play in fostering global social progress, How is the global social...

How is the global social progress being measured today? Name some indicators of development progress that you believe reasonably reflect actual progress. What roles do corporate ci

Own price elasticity of demand, Suppose the own price elasticity of demand ...

Suppose the own price elasticity of demand for good X is -5, its income elasticity is 2, its advertising elasticity is 4, and the cross-price elasticity of demand between it and go

Example of inventory investment- accounting system, ACCOUNTING SYSTEM-EXAMP...

ACCOUNTING SYSTEM-EXAMPLE IV  Now consider the economy as in example III. In the next year same outputs were produced and the same incomes were paid out. However, the household

Federal communications commission, A few years ago, the Federal Communicati...

A few years ago, the Federal Communications Commission (FCC) eliminated a rule that required Baby Bells to provide rivals access and discounted rates to current broadband facilitie

Negotiations between customers, In 1999 Mercedes-Benz USA adopted a new pri...

In 1999 Mercedes-Benz USA adopted a new pricing policy, which it called NFP (negotiation-free process), that sought to eliminate price negotiations between customers and new-car de

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