this is my advanced operation and supply chain management course please give me answer with excel and theory and please do not send the answer which is already on chegg

Instructions

Read the case carefully to understand the situation of making this important decision of granting customers higher or lower prices based on the supply chain costs specific customers make. The case includes situational information, as well as numerical data, which should be combined to perform the appropriate analysis and reach the correct decision.

An Excel template is provided for guidance on performing supply chain cost analysis, dissecting costs among customers, and assessing customer profitability. Through the case questions, you are walked step by step to reach your final decision.

For grading, you should submit your Excel workbook, along with a word document answering and explaining case questions in detail. The Word document should be 2 to 3 pages. A brief introduction and conclusion to wrap up your findings should also be given.

Case Questions

Use the information in case Exhibits 1 and 2 and other necessary data in the case on activities and costs to develop an Activity-Based Cost system for JBI, i.e., how much each activity is costing JBI for each customer. Excel templates are available (Sheets 1 and 2) to guide your work.

Use this ABC system to determine customer profitability for Saver Superstore, Oscars Oddlots, Midewellen Supermarket, and Downtown Retail (Sheet 2 of the provided template).

Use your results from Sheet 2 to compare customer costs and profits of the traditional costing system to the ABC system you have designed in (1). According to your ABC system, would you recommend entertaining a lower price to Saver SuperStore?

Please note that only typed assignments in MS Excel will be accepted. Please answer the case questions in the Excel file (not by supplying a separate MS Word document).

i need excel and theory for this assignment

10:32 | chegg.com - Private | = Chegg| JOHNSON BEVERAGE INC. As piles tory - g a delivery yerda deve estableci M, Maria attain, trear. hter tamil that has a tap - just in time to me is the water was Thala thalatta h rasi ya, Mrsena is allian M ata has an unlal uy TN bates a r instate to tastes - 1 TM Paal - The Meeting | silar panel see h g h i at a Kacan vere pe angle of me test tata ne Thes ched See an paint paily -wea t, Mal, in This wa Thaayil Ha ni nilaa - Are tips Taa ta S1 2 all .. - - So if we This question hasn't been solved yet Ask an expert 10:32 chegg.com - Private = Chegg Jamon looked at the water and wait I don't think we can lower cur price Saver Supermake any money on this one. And just think if weather larger the them we'll have our other customers wanting the same thing specially the best I can see it now. Manhais ring to walk in that Oscar's iets his heard about the deal with Sam Smith been talking with that and they want theme Oscar's Cele local resere the edge of her as longe cum Jan Rodgers, the perime mwing candy This was the fine he had heard of the school thinking. We will You know, I'm not able to hear all Save Super cestomer. They buy lots of beverages, and they're deal with the place their onders en reader remember the last time we had to run in the war ander from them. Wheththu Stevem apreol, You're right to have to change my day schedule here they've ked for quick delivery. And they for Radenci I think about some of our other customen. They come over hele to anticipate that they'll be out of stock. Then they calls to deal with It seems like we have customers that we day. Why can't that competitor aer the came to believe that some of these comes are problemer Spot Maybe now to add we the way those the customers and the whole As Joinen lestement le malind Ram might be shtypes contre chaded in those comerci The replied, "Well, the more lumps. He hinchakes wything stated to handling the beverage the benes from the warchouches wording to the desig bevengon ver to the deck and bading them the delivery wych related to taking coordinating and singenden Best we pay the people in the sales office to take photos from the pervisory costo administer the order and smilingbridades related to delivering the beverages to the comme le cose delivery trucks, truck, and what we pay Jee pouple drive the trucks. It includes anything related to all these anders webing about like overtime, extra schooling stuff like that. And is includes what puy Marsha for what he does like iting these check in the so there's quite a bit of stuff in there So throughout this. So you're well This question hasn't been solved yet Ask an expert 10:32 chegg.com - Private = Chegg Jose thought about this. So you're in tut you are spending on the test And Sever "That's right." Rodgerslid Jo continued. But since or com costs heders, and since Ser Supreme allocating a large share of Swer Super "Tactly. The La med and couple of days collecting need some help from each of you try to find your time you dig Misbe sophisticated about how we look they marine the amount of the devoted to the following Friday Thomas promised to complete the profitable each of their meally was Acthy Analysis Before he let for the weekend. The decided to pull opere some out the customer service costs he had described in the organiseret sking the des, delivering the product expediting rules uting se le acho through the accounting system and determined how much of the actor service costs wmciated with each of these categories Table 1) Table 1. Comer services de por you by Area of activity Totals Product handing $12.00 Taking orders from come Delivering the product 1.000 Expediting deliver the Sales visitato Total UVAC-3203 Then, on Monday, Thomas met individually with Stevom. Kecha por Wia their help, he determined what he had to be the manier tech the customer service categories Table Table 2. Could by stivity Area of activity Prodet handling Number me Taking order from customer Number of the Delivering the product Numbers Expediting deliveries (other than mobile Number of expediciones Number of This question hasn't been solved yet Ask an expert 10:32 chegg.com - Private = Chegg Thomis determined from the commend that the sot 100.000 cases of beverages and proceed to purchase on the proye Sive checked the mileage records for the delivery vehicles and determined that the file had traveled a total of 44800 miles Redes we to determine where made 440 deliver. 2.500 of which were expedited deve. And finally, Kadi checked her trwal los to determine she had made a total of sales visit to the comme Thom's next step was to determath of these and we able to cach wstomer. Aan he was wie eine of the info of use relatively caully from the company reconds. Then hinges helped diterie comer um for the rest of the active Echipata for the for customers included in Thomas's fint report (1) SONGEN he SUR LES KONSON BERGEN www M Nam - This question hasn't been solved yet Ask an expert 10:32 | chegg.com - Private | = Chegg| JOHNSON BEVERAGE INC. As piles tory - g a delivery yerda deve estableci M, Maria attain, trear. hter tamil that has a tap - just in time to me is the water was Thala thalatta h rasi ya, Mrsena is allian M ata has an unlal uy TN bates a r instate to tastes - 1 TM Paal - The Meeting | silar panel see h g h i at a Kacan vere pe angle of me test tata ne Thes ched See an paint paily -wea t, Mal, in This wa Thaayil Ha ni nilaa - Are tips Taa ta S1 2 all .. - - So if we This question hasn't been solved yet Ask an expert 10:32 chegg.com - Private = Chegg Jamon looked at the water and wait I don't think we can lower cur price Saver Supermake any money on this one. And just think if weather larger the them we'll have our other customers wanting the same thing specially the best I can see it now. Manhais ring to walk in that Oscar's iets his heard about the deal with Sam Smith been talking with that and they want theme Oscar's Cele local resere the edge of her as longe cum Jan Rodgers, the perime mwing candy This was the fine he had heard of the school thinking. We will You know, I'm not able to hear all Save Super cestomer. They buy lots of beverages, and they're deal with the place their onders en reader remember the last time we had to run in the war ander from them. Wheththu Stevem apreol, You're right to have to change my day schedule here they've ked for quick delivery. And they for Radenci I think about some of our other customen. They come over hele to anticipate that they'll be out of stock. Then they calls to deal with It seems like we have customers that we day. Why can't that competitor aer the came to believe that some of these comes are problemer Spot Maybe now to add we the way those the customers and the whole As Joinen lestement le malind Ram might be shtypes contre chaded in those comerci The replied, "Well, the more lumps. He hinchakes wything stated to handling the beverage the benes from the warchouches wording to the desig bevengon ver to the deck and bading them the delivery wych related to taking coordinating and singenden Best we pay the people in the sales office to take photos from the pervisory costo administer the order and smilingbridades related to delivering the beverages to the comme le cose delivery trucks, truck, and what we pay Jee pouple drive the trucks. It includes anything related to all these anders webing about like overtime, extra schooling stuff like that. And is includes what puy Marsha for what he does like iting these check in the so there's quite a bit of stuff in there So throughout this. So you're well This question hasn't been solved yet Ask an expert 10:32 chegg.com - Private = Chegg Jose thought about this. So you're in tut you are spending on the test And Sever "That's right." Rodgerslid Jo continued. But since or com costs heders, and since Ser Supreme allocating a large share of Swer Super "Tactly. The La med and couple of days collecting need some help from each of you try to find your time you dig Misbe sophisticated about how we look they marine the amount of the devoted to the following Friday Thomas promised to complete the profitable each of their meally was Acthy Analysis Before he let for the weekend. The decided to pull opere some out the customer service costs he had described in the organiseret sking the des, delivering the product expediting rules uting se le acho through the accounting system and determined how much of the actor service costs wmciated with each of these categories Table 1) Table 1. Comer services de por you by Area of activity Totals Product handing $12.00 Taking orders from come Delivering the product 1.000 Expediting deliver the Sales visitato Total UVAC-3203 Then, on Monday, Thomas met individually with Stevom. Kecha por Wia their help, he determined what he had to be the manier tech the customer service categories Table Table 2. Could by stivity Area of activity Prodet handling Number me Taking order from customer Number of the Delivering the product Numbers Expediting deliveries (other than mobile Number of expediciones Number of This question hasn't been solved yet Ask an expert 10:32 chegg.com - Private = Chegg Thomis determined from the commend that the sot 100.000 cases of beverages and proceed to purchase on the proye Sive checked the mileage records for the delivery vehicles and determined that the file had traveled a total of 44800 miles Redes we to determine where made 440 deliver. 2.500 of which were expedited deve. And finally, Kadi checked her trwal los to determine she had made a total of sales visit to the comme Thom's next step was to determath of these and we able to cach wstomer. Aan he was wie eine of the info of use relatively caully from the company reconds. Then hinges helped diterie comer um for the rest of the active Echipata for the for customers included in Thomas's fint report (1) SONGEN he SUR LES KONSON BERGEN www M Nam - This question hasn't been solved yet Ask an expert