Glascro Company manufactures skis. The management accountant wants to calculate the fixed and variablecosts associated with the leasing of machinery. Data for the past four months were collected as follows:Month Lease costMachine hoursApril$15,000800May10,000600June12,000770July16,0001,000Using the Method of Least Squares, calculate the fixed cost of leasing. Round the fixed cost to the nearestcent.

The Least-Squares regression model is a statistical technique. It is used to estimate a linear total…

Answered: Jsing the Method of Least Squares,…

Business

Operations Management

Jsing the Method of Least Squares, calculate the fixed cost of leasing. Round the fixed cost to the nearest ent.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 35P

See similar textbooks

Similar questions

If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.
It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.
The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
Type the linear program, optimal solution, and objective function value in a word document. Submit your excel file. An investor wishes to invest some or all of his $12.5 million in a diversified portfolio through a commercial lender. The types of investments, the expected interest per year, and the maximum allowed percentage investment he will consider are shown on the following table. He wants at least 35% of his investments to be in nonmortgage instruments and no more than 60% to be in high-yield (and high-risk) instruments (i.e., expected interest > 8%). How should his investment be diversified to make the most interest income? Investment Expected Return Maximum Allowed Low-income mortgage loans 6.50% 20% Conventional mortgage loans 6.00% 30% Government sponsored mortgage loans 8.25% 25% Bond investments 5.75% 15% Stock investments 8.75% 18% Futures trading 9.25% 10%
Asilekpe Company Limited is considering constructing a borehole in the village of Adukofe. The construction would cost Gh₵2 million and there will be no cost of maintenance. The following table shows the company’s anticipated demand over the lifetime of the bridge: Price per gallon (Gh₵) Number of gallons 8 0 7 100000 6 200000 5 300000 4 400000 3 500000 2 600000 1 700000 0 800000 a. If the company were to construct the borehole what would be its profit-maximizing price? Would that be the efficient level of output? Explain your answer.b. If the company is interested in maximizing profit, should it construct the borehole? What would be its profit or loss?c. If the government were to construct the borehole, what price should it charge? d. Should the government construct the borehole? Explain.
During the year, Brownout Company experienced the following power outages:Number of Power Outages Per Month Number of Months 0 3 1 2 2 4 3 3 12Each power outage results in out of pocket costs of P400. For P500 per month, the company can lease an auxiliary generator to provide power during outages. If the company leases an auxiliarygenerator next year, the estimated savings (or…
A goldsmith makes two types of jewelry. A model A ring is made with 1 g of gold and 1.5 g of silver and sells for 25 UM.Another model B ring sells for 30 UM and is made of 1.5 g of gold and 1 g of silver. If you only have 750 gof each metal, how many rings should be made of each type to obtain maximum profit?Requested:- Make Initial Table of the problem.- Obtain the Case Variables- Obtain the Objective Function- Get Restrictions- Create the Simplex Table- Obtain the Optimal Solution and the Slack Variables.Solve this operational research exercise.
For a table manufacturing company, selling price for a table is $183.00 per Unit, Variable cost is $25.00 per Unit, rent is $3,380.00 per month and insurance is $296.00 per month. Company wants to expand its business and improve the table quality, it wants to increase the selling price for a table to $254.00 per Unit, Variable cost to $43.00 per Unit, bigger area will have rent $5,235.00 per month and insurance is $362.00 per month At what point will the company be indifferent between the current mode of operation and the new option?
The cost data for Evencoat Paint for the year 2019 is as follows: Month Gallons ofPaintProduced EquipmentMaintenanceExpenses January 110,000 $70,700 February 68,000 66,800 March 71,000 67,000 April 77,000 68,100 May 95,000 69,200 June 101,000 70,300 July 125,000 70,400 August 95,000 68,900 September 95,000 69,500 October 89,000 68,600 November 128,000 72,800 December 122,000 71,450 A. Using the high-low method, express the company’s maintenance costs as an equation where x represents the gallons of paint produced. Then estimate the fixed and variable costs. Fixed cost $ Variable cost $
Bob and Dora Sweet wish to start investing $1,000 each month. The Sweets are looking at five investment plans and wish to maximize their expected return each month. Assume interest rates remain fixed and once their investment plan is selected they do not change their mind. The investment plans offered are: Fidelity 9.1% return per year Optima 16.1% return per year CaseWay 7.3% return per year Safeway 5.6% return per year National 12.3% return per year Since Optima and National are riskier, the Sweets want a limit of 30% per month of their total investments placed in these two investments. Since Safeway and Fidelity are low risk, they want at least 40% of their investment total placed in these investments.Formulate the LP model for this problem, using the standard LP format. Remember to define the objective function, the decision variables, and label the constraint functions. There is no need to solve the problem. Note:- Do not provide handwritten solution. Maintain…
The Big Bang Theory Assume the hours needed to cook a meal or done a basket of laundry are different, and they are described below: 1 MEAL 1 BASKET SHELDON 2 1 LEONARD 1/2 2 1. What is the maximum number of meals Sheldon can produce in 12 hours? What is the maximum number of laundry baskets Sheldon can complete in 12 hours? 2. Plot in a graph: Sheldon’s production possibility frontier. 3: Plot in a graph: Leonard’s production possibility frontier. 4. What is Sheldon’s opportunity cost of one meal (in terms of baskets given up)? What is his opportunity cost of one basket (in terms of meals given up)? 5. Does Leonard have an absolute advantage in producing both meals and baskets? 6. Who has a comparative advantage in cooking? 7. Suppose each person has 12 hours for the two tasks in a week, and suppose both Sheldon and Leonard each spend 6 hours on cooking and 6 hours on laundry. Consider an offer from Leonard to Sheldon: do 3 baskets of laundry for me each week, and I’ll cook you 2…
The Morton Supply Company Produces clothing, footwear, and accessories for dancing andgymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of theirtoes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The numberof square inches of each type of material used in each model of shoe, the amount of material available,and the profit/model are shown below.Material(measured inSquareinches)Model1Model2Model3MaterialavailableCardstock 12 10 14 1200Satin 24 20 15 2000Plain Fabric 40 40 30 7500Leather 11 11 10 1000Profit permodel$50 $44 $40a. Identify the decision variables, objective function, and constraints in simple verbal statements.b. Mathematically formulate a linear optimization model.Implement the linear optimization model that you developed for the Morton Supply Company inProblem #1 on a spreadsheet and use Excel Solver to find an optimal solution. Interpret the Excel SolverAnswer Report and identify the…