You are an associate of the American Coffee Producers Association and operate small coffee shops in southern Nevada. The coffee business is quite competitive and small companies must compete with coffee giants like Starbucks. Therefore, it is important that you understand your local market demographics. One demographic you wish to study is whether there are differences in coffee consumption levels among various age groups. Understanding any relationship between age and coffee consumption will help tailor effective promotional issues. You develop and administer a survey in your target market area. Two of the questions on the survey ask 1) the respondent's age range and 2) the respondent's level of daily coffee consumption. The results of the survey are shown in the table below. Perform the appropriate test at alpha = .05 to determine if the level of daily coffee consumption is related to customer age.  Note: this problem required the use of Minitab for step 3. Please could attach the file of the Minitab picture. Thank you!

Respondent's Age Group:

Daily Consumption Level:; < 30 Years; 30 to < 40 Years; 40 < 50 Years; 50 and Older;

Low (less than 2 cups) 36; 15; 10; 26

Moderate (2 to 3 cups) 32; 30; 24; 24

High (more than 3 cups) 21; 27; 20; 22

Company ABC is considering opening warehouses in four cities in Canada: Ottawa, Toronto, Calgary and Winnipeg. Each warehouse can ship 100 units per day. The daily fixed cost of keeping each warehouse open is $400 for Ottawa, $500 for Toronto, $300 for Calgary and $350 for Winnipeg. Region 1 of the country requires 80 units per day, region 2 requires 70 units per day and region 3 requires 40 per day. The costs (including production and shipping costs) of sending one unit from plant to a region are shown below in the table. The company wants to meet daily demands at a minimum cost subject to the preceding information and following restrictions:

To ($): From Region 1 Region 2 Region 3
Ottawa 20 40 50
Toronto 48 15 26
Calgary 26 35 18
Winnipeg 24 50 35

a) If Ottawa warehouse is opened, then Calgary warehouse must be opened.

b) At most two warehouses can be opened

c) Either Winnipeg or Calgary warehouse must be opened.

The company wants to minimize the daily cost of meeting demand.

1. Formulate algebraically a Binary/Integer Programming (BIP) model for this problem.

2. Use Excel Solver to solve the resulting BIP. (Include both formulation and answer report)

3. Describe clearly the optimal solution to this problem using a managerial statement to make a recommendation to the leadership of company ABC.

Process Cost Excel Project

Create a new Excel spreadsheet and name it “Last name_PC”. You project is to create a model for a production cost report using the weighted average method for the month of May.   Following good Excel design techniques, you should have an input area in which you put the department information for the month, and an output area that calculates the production cost report. As always, you should have only formulas or references in your output area. You should also include directions (in a text box) for users.

After completion of the production cost report using the weighted average method, create a new worksheet and label the tab “FIFO”. Create a production cost report using the same information using the FIFO method.

Department Data:

Process Cost Project – non-Excel

Answer questions 1 – 4. Use your Excel spreadsheet to answer questions 5 - 9

Process Cost Excel Project

Create a new Excel spreadsheet and name it “Last name_PC”. You project is to create a model for a production cost report using the weighted average method for the month of May.   Following good Excel design techniques, you should have an input area in which you put the department information for the month, and an output area that calculates the production cost report. As always, you should have only formulas or references in your output area. You should also include directions (in a text box) for users.

After completion of the production cost report using the weighted average method, create a new worksheet and label the tab “FIFO”. Create a production cost report using the same information using the FIFO method.

Department Data:

Process Cost Project – non-Excel

Answer questions 1 – 4. Use your Excel spreadsheet to answer questions 5 - 9

Process Cost Excel Project

Create a new Excel spreadsheet and name it “Last name_PC”. You project is to create a model for a production cost report using the weighted average method for the month of May.   Following good Excel design techniques, you should have an input area in which you put the department information for the month, and an output area that calculates the production cost report. As always, you should have only formulas or references in your output area. You should also include directions (in a text box) for users.

After completion of the production cost report using the weighted average method, create a new worksheet and label the tab “FIFO”. Create a production cost report using the same information using the FIFO method.

Department Data:

Process Cost Project – non-Excel

Answer questions 1 – 4. Use your Excel spreadsheet to answer questions 5 - 9

Dave Merrill vacationed at Lake Tahoe last winter.​ Unfortunately, he broke his ankle while skiing and spent two days at the Sierra University Hospital. Merrill​'s insurance company received a $4,400

bill for his​ two-day stay.

One item that caught Merrill​'s attention was an $11.75 charge for a roll of cotton. Merrill

is a salesman for Johnson​ & Johnson and knows that the cost to the hospital of the roll of cotton is between $2.15 to $2.95. He asked for a breakdown of the $11.75 charge. The accounting office of the hospital sent him the following​information:

Merrill believes the overhead charge is outrageous. He​ comments, "There was nothing I could do about it. When they come in and dab your​ stitches, it's not as if you can​ say, 'Keep your cotton roll. I brought my​ own.'"

You have been asked to forecast the additional funds needed (AFN) for Houston, Hargrove, & Worthington (HHW), which is planning its operation for the coming year. The firm is operating at full capacity. Data for use in the forecast are shown below. However, the CEO is concerned about the impact of a change in the payout ratio from the 10% that was used in the past to 50%, which the firm's investment bankers have recommended. Based on the AFN equation, by how much would the AFN for the coming year change if HHW increased the payout from 10% to the new and higher level? All dollars are in millions.

Maximax, Maximin, Minimax Regreat, Hurxicz 0.4, Equal liklihood

Periodic inventory by three methods; cost of goods sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 40 units at $124 Mar. 10 Purchase 50 units at $136 Aug. 30 Purchase 20 units at $142 Dec. 12 Purchase 90 units at $144 There are 60 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the ending inventory cost and the cost of goods sold by three methods. Round interim calculations to one decimal and final answers to the nearest whole dollar. Cost of Ending Inventory and Cost of Goods Sold Inventory Method Ending Inventory Cost of Goods Sold First-in, first-out (FIFO) $ $ Last-in, first-out (LIFO) Weighted average cost PreviousNext

Periodic Inventory by Three Methods; Cost of Merchandise Sold

The units of an item available for sale during the year were as follows:

There are 80 units of the item in the physical inventory at December 31. The periodic inventory system is used.

Determine the inventory cost and the cost of merchandise sold by three methods. Round interim calculations to one decimal and final answers to the nearest whole dollar.