“ slack fill ” cases concern consumer products B u s i n e s s F i n a n c e

“ slack fill ” cases concern consumer products B u s i n e s s F i n a n c e

Golden Food Company

The law firm Wi, Cheatem & Howe has hired you as an expert to evaluate a potential “slack fill” case involving the Golden Food Company. “Slack fill” cases concern consumer products being sold under the stated label weight/volume.

Wi, Cheatem & Howe – a law firm not associated with Golden Food — received a tip from an hourly supervisor working at Golden Food who claims the plant manager purposely and routinely under-fills cups of Matcha Whipped Spreads that have a stated label weight of 8 ounces. In this way, the insider tipster claims, the company saves money and the plant manager pads her bonus.

Your assistant collected sample data. Analyze the data based on the company’s packaging and the tipster’s claim.#

Steps:

1 Open the Golden Food data (Book6)

2 Click on Cell G9 (It’s a non-protected cell.) so it’s selected, then from the formula bar Click fx:

3 In the pop-u box: for Or Select Category select STATISTICAL from the dropdown menu.

4 In Cell G9 select AVERAGE, and input A7:A46 in the first dialogue box and then click OK.

5 In Cell G10: select STDEV (It may be STDEV.S), using A7:A46 in the first dialogue box & click OK.

6 In Cell G11: select COUNT, using A7:A46 in the first dialogue box & click OK.

7 The Comparison HT Data should now be complete.

See Assignment Submission Form:

A State your test decision* and recommendation based on the analysis of your results.

B Your statements should be concise and clear.

C By putting your name on the Assignment Submission Form you are agreeing that the work and

words are solely and wholly your work and your words.

D Feel free to move headings for formatting purposes.

*Test Decision means Step 5 of the hypothesis test. Do not state all the steps of a hypothesis test.

Mermaids Franchise

Mermaid’s Franchise has established locations in 7 states. As part of their expansion plan, Franchica is licensed to open Mermaid Franchise locations in Texas and Oklahoma.

Mermaid’s Corporate HQ’s has sent a corporate evaluator to inspect Franchica’s 9 newly opened Texas locations. Evaluator rated each location on Service, Quality, Cleanliness, Ambiance, and Employee Knowledge, along with a combined Overall Rating (O-Rating). The average O-Rating for all locations as established by Mermaid’s Corporate HQs is 92.4.

Analyze Franchica’s O-Rating compared to Mermaid’s Corporate number and interpret the results for the VP of Franchise Relations.#

1 Open the Memaid’s data (Book6)

2 Click on Cell G9 (It’s a non-protected cell.) so it’s selected, then from the formula bar Click fx:

3 In the pop-u box: for Or Select Category select STATISTICAL from the dropdown menu.

4 In Cell G9 select AVERAGE, and input B7:B15 in the first dialogue box and then click OK.

5 In Cell G10: select STDEV (It may be STDEV.S), using B7:B15 in the first dialogue box & click OK.

6 In Cell G11: select COUNT, using B7:B15 in the first dialogue box & click Ok.

7 The Comparison HT Data should now be complete.

See Assignment Submission Form:

A State your test decision* and interpretation of the test results.

B Your statements should be concise and clear.

*Test Decision means Step 5 of the hypothesis test. Do not state all the steps of a hypothesis test.

Confidence Interval: Use the provided CI Calculator to create a 99% CI for Mermaid’s franchise.

Assignment Submission Form:

1 Complete the written portion on page 1. Anything written beyond the first page may not be read

and will results in points being deducted.

2 On Page 2 of the Submission Form, Copy & Paste

● Golden Food’s output table into left image box,

● Mermaid’s output table into right image box,

● Mermaid’s CI tables as one image [Cells C6:S18] into bottom image box

3 You may need to PASTE SPECIAL PICTURE or PASTE SPECIAL BITMAP so copied images paste

cleanly and clearly into the space provided.