Answered: R(h,s)=200h0,5s0,5, where h is hours of…

R(h,s)=200h0,5s0,5, where h is hours of labour and s is tons of steel. Your total budget is €37950, what is the maximum possible revenue you could earn?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 40P

See similar textbooks

Similar questions

you are thinking of opening a small copy shop. It costs $5000 to rent a copier for a year, and it cost $0.03 per copy to operate the copier. Other fixed costs of running the store withh amount to $400 per month. You plan to charge $0.10 per copy, and the store will be open 365 days per year. Each copier can make up to 100,000 copies per year. a. for one to five copiers rented and daily demands of 500, 1000, 1500, 2000 copies perday, find annual profit. That is, find annual profit for each of these combinations of copiers rented and daily demand. b. if you rent three copies, what daily demand for copies will allow you to break even? c. Graph profit as a function of the number of copiers for a daily demand of 500 copiers; for a daily demand of 2000 copies. Interpret your graph
Assume the demand for a company’s drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year,it will cost $16x. Each unit of Wozac is soldfor $3. Each unit of Wozac produced -incurs a variable production cost of $0.20. It costs $0.40 per year to operate a unit of capacity.Determine how large a Wozac plant the company should build to maximize its-expected profit over the next 10 years.
You are thinking of opening a small copy shop. It costs $5000 to rent a copier for a year, and it costs $0.03 per copy to operate the copier. Other fixed costs of running the store will amount to $400 per month. You plan to charge an average of $0.10 per copy, and the store will be open 365 days per year. Each copier can make up to 100,000 copies per year. a. For one to five copiers rented and daily demands of 500, 1000, 1500, and 2000 copies per day, find annual profit. That is, find annual profit for each of these combinations of copiers rented and daily demand. b. If you rent three copiers, what daily demand for copies will allow you to break even? c. Graph profit as a function of the number of copiers for a daily demand of 500 copies; for a daily demand of 2000 copies. Interpret your graphs.
A retired couple supplement their income by making fruit pies, which they sell to a local grocery store. During the month of September, they produce apple and grape pies. The apple pies are sold for $10.00 to the grocer, and the grape pies are sold for $8.00. The couple is able to sell all of the pies they produce owing to their high quality. They use fresh ingredients. Flour and sugar are purchased once each month. For the month of September, they have 1,500 cups of sugar and 2,400 cups of flour. Each apple pie requires 1½ cups of sugar and 3 cups of flour, and each grape pie requires 2 cups of sugar and 3 cups of flour. a. Determine the number of grape and the number of apple pies that will maximize revenues if the couple working together can make an apple pie in 6 minutes and a grape pie in 3 minutes. They plan to work no more than 60 hours. (Round your answers to nearest whole number.) b. Determine the amounts of sugar, flour, and time that will be unused. (Leave no cells blank -…
You operate a small wooden toy company making two products: alphabet blocks and wooden trucks. Your profit is $30 per box of blocks and $40 per box of trucks. Producing a box of blocks requires one hour of woodworking and two hours of painting; producing a box of trucks takes three hours of woodworking, but only one hour of painting. You employ three woodworkers and two pointers, each working 40 hours a week. How many boxes of block (B) and trucks (T) should you make each week to maximize profit? Solve graphically as a linear program and confirm analytically.
A retired couple supplement their income by making fruit pies, which they sell to a local grocery store. During the month of September, they produce apple and grape pies. The apple pies are sold for 2.00 to the grocer, and the grape pies are sold for 4.00. The couple is able to sell all of the pies they produce owing to their high quality. They use fresh ingredients. Flour and sugar are purchased once each month. For the month of September, they have 2100 cups of sugar and 3000 cups of flour. Each apple pie requires 1 1/2 cups of sugar and 3 cups of flour, and each grape pie requires 2 cups of sugar and 3 cups of flour. a. determine the number of grape and the number of apple pies that will maximize revenues if the couple working together can make and apple pie in 6 minutes and a grape pie in 3 minutes.…
Cantel Company produces cleaning compounds for both commercial and household customers. Some of these products are produced as part of a joint manufacturing process. For example, GR37, a coarse cleaning powder meant for commercial sale, costs $1.90 a pound to make and sells for $2.00 per pound. A portion of the annual production of GR37 is retained for further processing in a separate department where it is combined with several other ingredients to form SilPol, which is sold as a silver polish, at $5.00 per unit. The additional processing requires 1/4 pound of GR37 per unit; additional processing costs amount to $3.90 per unit of SilPol produced. Variable selling costs for SilPol average $0.50 per unit. If production of SilPol were discontinued, $1,000 of costs in the processing department would be avoided. Cantel has, at this point, unlimited demand for, but limited capacity to produce, product GR37. Required: 1. Calculate the minimum number of units of SilPol that would have to be…
I need a detailed assistance to solve this problem in: Operations Analysis. 3) A chemical manufacturer produces a compound at the rate of 10,000 pounds a day over 250 days each year. Annual demand for that compound is 600,000 pounds per year, and each pound sells for $3.90. There is a fixed setup cost of $1,500 for each production run, and a variable cost of $3.50 for each pound produced. The following costs are incurred: Interest rate on the cost of capital is 22% per annum (annually). Storage and handling costs amount to 12% of the compounds cost per annum. a)- What is the optimal production lot for the compound (write down the model name, its parameters and formula)? b)- Compute the uptime, downtime and cycle time in days, and find the cycle fraction of uptime and the cycle fraction of downtime (include the formula). c)- What are average annual holding and setup costs for the compound (include the formula)? d) - What is the annual profit for this compound?
Think of an enterprise that produces “C” kind fire extinguishers. They manufacture 30,000extinguishers per year. Each extinguisher requires a handle. Suppose that the storage cost is1.5 dollars per handle, the production preparation cost is 150 dollars and the daily productionratio is 300. A labour year is 300 days. Which will the optimal amount of production be?
A retired couple supplement their income by making fruit pies, which they sell to a local grocery store. During the month of September, they produce apple and grape pies. The apple pies are sold for $1.50 to the grocer, and the grape pies are sold for $1.20. The couple is able to sell all of the pies they produce owing to their high quality. They use fresh ingredients. Flour and sugar are purchased once each month. For the month of September, they have 1,200 cups of sugar and 2,100 cups of flour. Each apple pie requires 1 1⁄2 cups of sugar and 3 cups of flour, and each grape pie requires 2 cups of sugar and 3 cups of flour. a. Determine the number of grape and the number of apple pies that will maximize revenues if the couple working together can make an apple pie in six minutes and a grape pie in three minutes. They plan to work no more than 60 hours. b. Determine the amounts of sugar, flour, and time that will be unused.
Stan Moneymaker needs 15 gallons of gasoline to top off his automobile’s gas tank. If he drives an extra eight miles (round trip) to a gas station on the outskirts of town, Stan can save $0.10 per gallon on the price of gasoline. Suppose gasoline costs $3.90 per gallon and Stan’s car gets 25 mpg for in-town driving. Should Stan make the trip to get less expensive gasoline? Each mile that Stan drives creates one pound of carbon dioxide. Each pound of CO2 has a cost impact of $0.02 on the environment. What other factors (cost and otherwise) should Stan consider in his decision making?
A person sells and installs A, B and C. The table shows, for example, that it takes 3 hours to sell a unit of B, it takes 4 hours to install it, and net profit per unit is $ 40. Product No. of Units Selling Hours per Unit Installation Hours per Unit Profit per Unit A x 1 1 $10 B y 3 4 40 C z 2 1 10 During a 38-hour week, the person allots no more than 18 hours to selling and no more than 20 hours to installation. Find the combination of number of units of A, B, C that would yield maximum profit.