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

Principle of opportunity cost applies to your life, Give an example of how ...

Give an example of how the Principle of Opportunity Cost applies to your life. Think of a recent decision you made. It could be a decision as simple as whether to eat out or cook y

E.., law of indefference curve

law of indefference curve

At some number payment is fixed, The United States Treasury borrows money ...

The United States Treasury borrows money on behalf of the federal government all the time. One type of the government borrowing, called a treasury bills, promises a fixed payment a

What is money supply, What is Money supply The monetary base is only a ...

What is Money supply The monetary base is only a small part of the total money supply but, through the multiplier effect, the central bank's control over the money supply is ma

Strategy for p1 in this game, P2 and P3 play with a penny. P1 picks between...

P2 and P3 play with a penny. P1 picks between same (S) and different (D). After observing P1's choice, P2 and P3 get to picked Simultaneously independently either head (H) and tail

Public sector, Are there any current subsidy or welfare issues that are bei...

Are there any current subsidy or welfare issues that are being discussed or addressed in parliament or in municipalities

Monetary base and the supply of money, Q. Monetary base and the supply of m...

Q. Monetary base and the supply of money? It isn't possible for central bank to print and distribute money -which would increase their debt without increasing their assets. Rat

Economic functions of money, Money is generally considered to have three ec...

Money is generally considered to have three economic functions: A medium of exchange. This is its most significant role. Without money we would live in a barter economy wher

Aggregate supply and demand, Aggregate Supply and Demand 1. The equati...

Aggregate Supply and Demand 1. The equation for expenditure GDP is 2. Sketch a fully labeled aggregate supply and demand diagram for an economy that is in full employment equ

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

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