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

Economy, Compare Classical economic theory to Keynesian economic theory. Wh...

Compare Classical economic theory to Keynesian economic theory. Which approach, if either is the US currently applying and what have been the effects of such policies?

How to find nominal gdp in the current year, Consider an economy that produ...

Consider an economy that produces only three types of fruit: apples, oranges & bananas. In the base year the production & price data are as follows: Fruit

Show the advantage and disadvantage of money, Q. Show the advantage and dis...

Q. Show the advantage and disadvantage of money? Money has one significant advantage and one disadvantage compared to bonds:  · Advantage: Money is more liquid than bond

Monetary policy, Let us now see a bit more closely how monetary policy work...

Let us now see a bit more closely how monetary policy works. See Figure Figure  The initial equilibrium at point E is on the initial LM schedule that corresponds to a

Concept of taxation, The Concept of Taxation is explained below: Taxes ...

The Concept of Taxation is explained below: Taxes are the general purpose, compulsory contributions by people to the public treasury (or national exchequer) to meet the expendi

Classical business cycle theory, The rate of interest in the UK also showed...

The rate of interest in the UK also showed very interesting results, to an impulse shock on oil price. The middle left graph from Fig 4.4 shows the results. Initially, in the short

Demand for a product, 1. Suppose the demand for a product is given by QD = ...

1. Suppose the demand for a product is given by QD = 2000 - 25P. a) Calculate the Price Elasticity of Demand when the price is $30. b) What price should the firm charge if it

Illustrate the about term the open economy in short, Illustrate the about t...

Illustrate the about term the open economy in short. The Open Economy: a. A closed economy is an economy which does not trade goods-services as well as assets. b. The Uni

Problem with the keynesian model, The problem with the Keynesian model ...

The problem with the Keynesian model We can classify two problems with the Keynesian model as developed so far: 1. Π is exogenous. Although inflation may temporarily deviate

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