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

Illustrate the definition of money, Definition of Money We should defi...

Definition of Money We should define what we mean by money. Money has a long as well as interesting history and an understanding of how we came to use money is useful for any

Describe in detail about exchange rate systems, Describe in detail about Ex...

Describe in detail about Exchange rate systems Various countries have different exchange rate systems. The most significant characteristic of an exchange rate system is to what

Consumption and GDP, At first, it may seem obvious that consumption will re...

At first, it may seem obvious that consumption will rely on Y. If GDP is doubled in real terms over a number of years, government consumption, private consumption and investment wi

Draw game in two standard forms, Consider the following game [payoffs are i...

Consider the following game [payoffs are in the form: (Ann, Bob, Carol)]: a) List each player's actions and strategies. b) If Ann "buys" Carol's position in the game (i.

Revenue theory, calculate, a.the total revenue b.the average revenue c.the ...

calculate, a.the total revenue b.the average revenue c.the marginal revenue price 5 4 3 2 1 0 quantity 0 1 2 3 4 5.

Difference among federal income tax and a federal sales, How could utility ...

How could utility theory help us understand the difference between a federal income tax and a federal sales tax on consumer consumption patterns?

Obtain a histogram of systolic blood pressure, The data set lowbwt.sav co...

The data set lowbwt.sav contains information for a sample of 100 low birth weight infants born in two teaching hospitals in Boston. Measurements of systolic blood pressure are sa

Lower tax rates, Is it true that government revenues are increased because ...

Is it true that government revenues are increased because of lower tax rates? Ans) It is true to a point. The Laffer curve determines that revenues enhance as the tax rates rise

Money illusion, A significant argument for the augmentation has to do with ...

A significant argument for the augmentation has to do with concept of money illusion. Money illusion means that you care about nominal rather than real amounts. Imagine that your s

Circular flow – circulation of goods, Figure below demonstrates a more deve...

Figure below demonstrates a more developed version of the circular flow. In this figure we see how goods flow through various sectors of the economy. Figure Money in the c

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