Question

In: Statistics and Probability

Salvatore Auto Supplies has retail stores located in in eight cities in Ohio. The price they...

Salvatore Auto Supplies has retail stores located in in eight cities in Ohio. The price they charge for a particular product in each city varies because of differing competitive conditions. The price they charge for a popular brand of motor oil in each city is provided in the table below, along with the number of cases that Salvatore Auto Supplies sold last quarter in each city.

City

Price ($)

Sales (cases)

Cleveland

34.99

401

Columbus

34.14

1425

Cincinnati

37.25

294

Toledo

35.15

882

Akron

42.17

751

Chillicothe

38.59

1015

Youngstown

38.65

1464

Sandusky

37.99

609

Calculate the average sales price per case for this product during the last quarter. (round your answer to 2 decimal places, using conventional rounding rules)

ANSWER: $ per case

Solutions

Expert Solution

We are provided with the data which provides information about the price they charge for a particular product along with the number of cases that Salvatore Auto Supplies sold last quarter in each city.

Inorder to calculate the average sales price per case for this product during the last quarter, we should first calculate the sales price per product for each city by dividing the sales price by the number of cases sold last quarter. Then sum up the sales price per product for each city and divide it by number of cities to get the average sales price per case for this product​ during last quarter.

There are totally 8 cities in the da

City

Price ($)

 Number of cases sold    Sales price per case   
Cleveland​ 34.99 401 0.08726
Columbus 34.14 1425 0.02395
Cincinnati 37.25 294 0.12670
Toledo 35.15 882 0.03985
Akron 42.17 751 0.05615
Chillicothe 38.59 1015 0.03802
Youngstown 38.65 1464 0.02640
Sandusky 37.99 609 0.06238

Thus sum of sales price per product is given by,

Total sales price per product (case)

  

Thus total sales price per case during the last quarter is 0.4607 $

AVERAGE SALES PRICE PER CASE:

Now the average sales price per case during the last quarter is total sales price per case divided by number of cities (since Salvatore Auto Supplies has retail stores located in eight cities).

Average sales price per case

Thus the average sales price per case for this product during the last quarter is 0.06 $

orchestra answered 2 years ago
Next > < Previous

Related Solutions

The selling price (in $) for the deluxe and standard model Ryobi wood sanders are shown for a sample of eight retail stores.
The selling price (in $) for the deluxe and standard model Ryobi wood sanders are shown for a sample of eight retail stores. Does the data suggest the difference in average selling price of these Ryobi models is more than $10 at alpha=.1 Retail Store Deluxe Standard 1 32 19 2 31 19 3 31 19 4 31 19 5 44 31 6 42 30 7 39 27 8 32 22 For the hypothesis stated above (in terms of Deluxe-Standard)...
A retail chain has eight stores in a region supplied from four supply sources. Trucks have...
A retail chain has eight stores in a region supplied from four supply sources. Trucks have a capacity of 40,000 units and cost $1,000 per load plus $100 per delivery. Thus, a truck making two deliveries charges $1,200. The cost of holding one unit in inventory at retail for a year is $0.20. • The vice president of the supply chain is considering whether to use direct shipping from suppliers to retail stores or setting up milk runs from suppliers...
A market research firm supplies manufacturers with estimates of the retail sales of their products from samples of retail stores.
A market research firm supplies manufacturers with estimates of the retail sales of their products from samples of retail stores. Marketing managers are prone to look at the estimate and ignore sampling error. An SRS of 29 stores this year shows mean sales of 74 units of a small appliance, with a standard deviation of 12.2 units. During the same point in time last year, an SRS of 26 stores had mean sales of 62.166 units, with standard deviation 15.2...
A retail dealer in Auto Parts is currently selling 15,000 AutoParts annually. He supplies the...
A retail dealer in Auto Parts is currently selling 15,000 Auto Parts annually. He supplies the following details for the year ended December 31, 2009DETAILSAMOUNT (Rs.)Seling Price Per Unit200Variable Cost Per unit120Fixed Costs :Staff Salaries3,00,000General Office Cost1,00,000Advertising Cost80,000(a) Calculate the break even point and margin of Safety.(b) Assume that 12,000 Auto Parts were sold during the year. Find out the net profit of the firmAssuming that in 2010 the rate of factory over heads went up by 20%, dist. expenses...
Case study The Bigga Izbetta retail group has 4 department stores, all located in New Zealand,...
Case study The Bigga Izbetta retail group has 4 department stores, all located in New Zealand, at Invercargill, Dunedin and on the Kaikoura and Akaroa Coasts. It is a family-owned company run along traditional lines. Employees work under a hierarchical system, transfers and promotions are regulated by a seniority system, everyone works to a detailed job description and employees are paid according to a fixed salary schedule. George’s recent appointment as the head of the menswear department at the Kaikoura...
Northern Distributors is a wholesale organization that supplies retail stores with lawn care and household products....
Northern Distributors is a wholesale organization that supplies retail stores with lawn care and household products. One building is used to store Neverfail lawn mowers. The building is 25 feet wide by 40 feet deep by 8 feet high. Anna Oldham, manager of the warehouse, estimates that about 60% of the warehouse can be used to store the Neverfail lawn mowers. The remaining 40% is used for walkways and a small office. Each Neverfail lawn mower comes in a box...
Question 7 Carna Ltd is a listed diversified retail company. Its stores are located mainly in...
Question 7 Carna Ltd is a listed diversified retail company. Its stores are located mainly in Australia. It has three main types of stores: general department stores, liquor stores, and specialist toy stores. Each of these stores has different products, customer types, and distribution processes. In accordance with AASB 8/IFRS 8, Carna Ltd has identified three operating segments: general stores, liquor stores, and toy stores. All three business units earn most of their revenue from external customers. Total The consolidated...
Harry’s Carryout Stores has eight locations. The firm wishes to expand by two more stores and...
Harry’s Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: Actual Forecast Additional Information November $320,000 January $400,000 April forecast $400,000 December 340,000 February 440,000 March 410,000 Of the firm’s sales, 60 percent are for cash and the...
Harry’s Carryout Stores has eight locations. The firm wishes to expand by two more stores and...
Harry’s Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: Actual Forecast Additional Information November $620,000 January $700,000 April forecast $550,000 December 640,000 February 740,000 March 560,000 Of the firm’s sales, 30 percent are for cash and the...
Harry’s Carryout Stores has eight locations. The firm wishes to expand by two more stores and...
Harry’s Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an acceptable three-month financial plan for January through March. The following are actual and forecast sales figures: Actual Forecast Additional Information November $420,000 January $500,000 April forecast $450,000 December 440,000 February 540,000 March 460,000 Of the firm’s sales, 40 percent are for cash and the...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT