Gator Beach Marts, a chain of convenience grocery stores in the Fort Lauderdale area, has store hours that fluctuate from month to month as the tourist trade in the community varies. The utility costs for one of the company’s stores are listed below for the past six months. Month Total Hours of Operation Total Utility Cost January 500 $ 2,120 February 600 2,400 March 750 2,850 April 450 2,050 May 400 1,750 June 350 1,650 Required: 1-a. Use the high-low method to estimate the cost behavior for the store’s utility costs. Express the cost behavior in formula form (Y= a + bX). 1-b. What is the variable utility cost per hour of operation? 3-a. Construct an Excel spreadsheet and use the Excel commands to perform a least-squares regression. Estimate the cost behavior for the store's utility cost. Express the cost behavior in formula form. 3-b. What is the variable utility cost per hour of operation? 4. During July, the store will be open 300 hours. Predict the store’s total utility cost for July using each of the cost-estimation methods employed in requirements (1) and (3).

Gator Beach Marts, a chain of convenience grocery stores in the Fort Lauderdale area, has store hours that fluctuate from month to month as the tourist trade in the community varies. The utility costs for one of the company’s stores are listed below for the past six months. Month Total Hours of Operation Total Utility Cost January 500 $ 2,120 February 600 2,400 March 750 2,850 April 450 2,050 May 400 1,750 June 350 1,650 Required: 1-a. Use the high-low method to estimate the cost behavior for the store’s utility costs. Express the cost behavior in formula form (Y= a + bX). 1-b. What is the variable utility cost per hour of operation? 3-a. Construct an Excel spreadsheet and use the Excel commands to perform a least-squares regression. Estimate the cost behavior for the store's utility cost. Express the cost behavior in formula form. 3-b. What is the variable utility cost per hour of operation? 4. During July, the store will be open 300 hours. Predict the store’s total utility cost for July using each of the cost-estimation methods employed in requirements (1) and (3).

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter11: Simulation Models

Section11.4: Marketing Models

Problem 30P: Seas Beginning sells clothing by mail order. An important question is when to strike a customer from...

See similar textbooks

Similar questions

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.
Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?
The following data pertain to the Oneida Restaurant Supply company for the year just ended. Budgeted sales revenue $205,000 Actual manufacturing overhead $340,000 Budgeted machine hours (based on capacity) 10,000 Budgeted direct-labor hours ( based on capacity) 20,000 Budgeted direct-labor rate $14 Budgeted manufacturing overhead $364,000 Actual machine hours 11,000 Actual direct-labor hours 18,000 Actual direct-labor rate $15 Compute the firm's predetermined overhead rate for the year using each of the following common cost drivers: a) machine hours, b) direct-labor hours, and c) direct-labor dollars.
Brady Corporation produces cabinets. Each week, itrequires 90,000 cu ft of processed lumber. The companymay obtain lumber in two ways. First, it may purchaselumber from an outside supplier and then dry it in thesupplier’s kiln. Second, it may chop down logs on its ownland, cut them into lumber at its sawmill, and finally dry thelumber in its own kiln. Brady can purchase grade 1 or grade2 lumber. Grade 1 lumber costs $3 per cu ft and when driedyields 0.7 cu ft of useful lumber. Grade 2 lumber costs $7per cubic foot and when dried yields 0.9 cu ft of usefullumber. It costs the company $3 to chop down a log. Afterbeing cut and dried, a log yields 0.8 cu ft of lumber. Bradyincurs costs of $4 per cu ft of lumber dried. It costs $2.50per cu ft of logs sent through the sawmill. Each week, thesawmill can process up to 35,000 cu ft of lumber. Eachweek, up to 40,000 cu ft of grade 1 lumber and up to 60,000cu ft of grade 2 lumber can be purchased. Each week, 40hours of time are available for…
A wood products firm uses available time at the end of each week to make goods for stock.Currently, two products on the list of items are produced for stock: a chopping board and a knifeholder. Both items require three operations: cutting, gluing, and finishing. The manager of thefirm has collected the following data on these products.TIME PER UNIT (MINUTES)Item Profit/Unit Cutting Gluing FinishingChopping board $2 1.4 5 12Knife holder $6 0.8 13 3The manager has also determined that, during each week, 56 minutes are available for cutting, 650minutes are available for gluing, and 360 minutes are available for finishing.a. Determine the optimal quantities of the decision variables if the goal is to maximize profit.b. Which resources are not completely used by your solution? How much of each resource isunused?
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…
Macnamara Corporation has two manufacturing departments--Casting and Finishing. The company used the following data at the beginning of the year to calculate predetermined overhead rates: Casting Finishing Total Estimated total machine-hours (MHs) 1,000 4,000 5,000 Estimated total fixed manufacturing overhead cost $ 4,800 $ 8,800 $ 13,600 Estimated variable manufacturing overhead cost per MH $ 1.80 $ 2.90 During the most recent month, the company started and completed two jobs--Job F and Job M. There were no beginning inventories. Data concerning those two jobs follow: Job F Job M Direct materials $ 11,500 $ 9,000 Direct labor cost $ 18,400 $ 7,400 Casting machine-hours 700 300 Finishing machine-hours 1,600 2,400 Assume that the company uses departmental predetermined overhead rates with machine-hours as the allocation base in both production departments. The manufacturing overhead applied to Job F is closest to: $4,620…
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…
The Scottville "Mill" produces five different fabrics. Each fabric can be woven on one or more of the mill's 38 looms. The sales department has forecast demand for the next month. The demand data are shown in Table 1.0 below along with data on the selling price per yard, variable cost per yard, and purchase price per yard. The mill operates 24 hours a day and is scheduled for 30 days during the coming month. The Mill has two types of looms: dobbie and regular. The dobbie looms are more versatile and can be used for all five fabrics. The regular looms can produce only three of the fabrics. The Mill has a total of 38 looms: 8 are dobbie and 30 are regular. The rate of production for each fabric on each type of loom is given in Table 1.1. The time to change over from producing one fabric to another is negligible and does not have to be considered. The Scottsville Mill satisfies all demand with either its own fabric or fabric purchased from another mill. Fabrics that cannot be woven at…
I need a detailed assistance to solve this problem in: Operations Analysis. #4) A greengrocer has exactly 1,000 square feet available to display and sells 3 kinds of vegetables. The space consumed by each kind of vegetable is proportional to its cost, and tomatoes consume 0.5 square feet per pound. There is a $100 setup cost for replenishing any of the vegetables, and the interest rate is 25% per annum. The 3 vegetables for sale have the following data: Tomatoes: annual demand is 850 pounds and the cost per pound is $0.29. Lettuce: annual demand is 1280 pounds and the cost per pound is $0.45. Zucchini: annual demand is 630 pounds and the cost per pound is $0.25. a) - What is the optimal quantity for purchasing each vegetable (include all formulas)?
Susan M. Brownell is the VP of supply management at the U.S. Postal Service (USPS). She is responsible for managing supplier relationships with over $12 billion in expenditures and $6 billion of inventory. 9 Many of these suppliers provide transportation and delivery services for USPS and its customers. In order to save taxpayer dollars, Brownell has been tasked with optimizing transportation costs for mail and pacl(age deliveries. At the same time, in order to compete with private competitors like FedEx, Brownell is expected to maintain, if not increase the quality of USPS delivery services. What are some of the transportation options available to Browning, and how should she evaluatewhich ones to use?
Nicki Fenty Corporation manufactures a variety of beauty products in several departments andevaluates departments and departmental managers by comparing actual cost and output relativeto the budget. Departmental managers help create the budgets and usually provide informationabout input quantities for materials, labor, and overhead costs.Chante Moore is the manager of the department that produces lip gloss. Chante hasestimated these inputs for Lip gloss:Input Budget quantity per unit of outputDirect materials 8 poundsDirect manufacturing labour 30 minutesMachine time 24 minutesThe department produces about 100 units of lip gloss each day. Chante’s department alwaysgets excellent evaluations, sometimes exceeding budgeted production quantities. For each 100units of lip gloss produced, the company uses, on average, about 48 hours of directmanufacturing labor (eight people working 6 hours each), 790 pounds of material, and 39.5machine-hours.Top management of Nicki Fenty Corporation has…