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

Currency, Assume that Jimmy Cash has $2100 in his checking account and uses...

Assume that Jimmy Cash has $2100 in his checking account and uses his checking card to withdraw $210 from his ATM machine. By what amount did M1 change from this individual transac

Case fair Oster, iN BOTH CITIES, AN INCREASE IN INCOME COMBINED WITH EXPECT...

iN BOTH CITIES, AN INCREASE IN INCOME COMBINED WITH EXPECTATIONS OF A STRONG MARKET SHIFTED DEMAND AND CAUSED PRICES TO RISE RAPLIDLY DURING THE MID-TO LATE 1980S. Illustrate with

To make a product workers concentrate on specialized tasks, The system wher...

The system where workers concentrate on specialized tasks to make a product is referred to as: A. Coincedence of wants B. Roundabout production C.Freedom of enterprise

Unemployment, critically analyse the ways at which the govement of zimbabwe...

critically analyse the ways at which the govement of zimbabwe has put in place to address unequal employment opportunitiesbetween men andwomen

Chartered a bus to atlanta, A group has chartered a bus to Atlanta. The dri...

A group has chartered a bus to Atlanta. The driver costs $200, the bus costs $500, and parking in Atlanta will be $90. You have already paid $700 to reserve the bus and a driver. T

Production manager for widgets, Suppose you are the production manager for ...

Suppose you are the production manager for Widgets, Inc. Your job is to produce a fixed amount of output at the lowest cost possible. When you take over the position, you find that

Explain the term- inventory investment, Explain the term- inventory investm...

Explain the term- inventory investment We would have a negative inventory investment whenever inventories decrease. By net investments we mean gross investments minus depreciat

Elasticity with respect to the price of gasoline, Suppose the annual demand...

Suppose the annual demand function for the Honda Accord is Qd = 430 - 10 PA + 10 PC - 10 PG where PA and PC are the prices of the Accord and the Toyota Camry respectively (in thous

Substitution and income effects in units, Individual A has UA(XA,YA)=lnXA+2...

Individual A has UA(XA,YA)=lnXA+2YA and has $500. PX=5 and PY =10. (a) Find the optimum. Show that it is indeed the maximum. (b) PX=10. Find the new optimum. (c) Calculate

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

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