XYZ Company is a food maker company which starts with its first project in Dammam. This...

   

Transcribed Image Text:

XYZ Company is a food maker company which starts with its first project in Dammam. This project is a restaurant where foods are served to customers 10 hours a day from 6 am till 4 PM. In order to put prices for each dish, the owner of the company is looking for an accountant to build a costing system that can generate the cost of each dish. Table1: Menu with Ingredients Meal 1 2345 French fries with cheese Eggs dish salad tea Coffee Item Eggs potato Slices. cheese. Oil Tomato Onion Flour Sugar cucumber. tea Coffee beans water Table 2: Average cost of ingredients i 15 SR 5 SR 5 SR 4 SR 15 SR Ingredients (per dish) 2 1 peace of slices cheese 10 SR 9 SR 18 SR 1 250 g potato 10 SR 2 eggs 1 tomato 1 tea bag 5 g Roasted Coffee beans Cost (total) Packages (# of units) Cost per unit S 15 SR 5 100 SR .01 10 SR 1 30 eggs 10 kilos 10 Slices 1 Tomato 1 Onion 1 cup water. 5 cup of water 30 Liters 25 Tomatoes 20 Opinions 16 cups 40 kilos 30 cucumbers 45 bags 50 g 60 liter 15 2 25 25 375 per g 3 2 -36 3 2 liter of oil 6 (Per cup) 5 peace of onion I Cucumber 10 g sugar 5 g sugar ACCT251 Names: 1- Meals # Direct labor hours. Machine hours Number of dishes served Direct labor cost Rent MOH Electricity Supervisor salary Deprecation TOTAL MOH 1 50 12 240 2000 Term Project ID... 2 20 8 400 8000 MEDIE 3 30 7 200 6000 4 15 2 180 2700 Score/10 5 24 TERM221 10 260 6240 Total 139 H 39 H 1280 24940 3000 4000 5000 1000 13,000 Based on the information presented in the above tables, solve the following requirements: Requirment1: Calculate the Predetermined overhead cost? Note: 1- For Electricity & Depreciation use Allocation base Machine hours 2- For Rent & Supervisor salary use the Direct labor Hours fill the above table of MOH based on the Allocation bae given fill the above table of MOH based on the Allocation bae given Reguirment2; calculate the total cost per unit of each dishes served in this restaurant? (Show your work) (Recommended to use Excel DL (Total) DM MOH Total Cost Cost Per Unit Dish#1 Dish#2 Dish#3 Dish#4 Dish#5 XYZ Company is a food maker company which starts with its first project in Dammam. This project is a restaurant where foods are served to customers 10 hours a day from 6 am till 4 PM. In order to put prices for each dish, the owner of the company is looking for an accountant to build a costing system that can generate the cost of each dish. Table1: Menu with Ingredients Meal 1 2345 French fries with cheese Eggs dish salad tea Coffee Item Eggs potato Slices. cheese. Oil Tomato Onion Flour Sugar cucumber. tea Coffee beans water Table 2: Average cost of ingredients i 15 SR 5 SR 5 SR 4 SR 15 SR Ingredients (per dish) 2 1 peace of slices cheese 10 SR 9 SR 18 SR 1 250 g potato 10 SR 2 eggs 1 tomato 1 tea bag 5 g Roasted Coffee beans Cost (total) Packages (# of units) Cost per unit S 15 SR 5 100 SR .01 10 SR 1 30 eggs 10 kilos 10 Slices 1 Tomato 1 Onion 1 cup water. 5 cup of water 30 Liters 25 Tomatoes 20 Opinions 16 cups 40 kilos 30 cucumbers 45 bags 50 g 60 liter 15 2 25 25 375 per g 3 2 -36 3 2 liter of oil 6 (Per cup) 5 peace of onion I Cucumber 10 g sugar 5 g sugar ACCT251 Names: 1- Meals # Direct labor hours. Machine hours Number of dishes served Direct labor cost Rent MOH Electricity Supervisor salary Deprecation TOTAL MOH 1 50 12 240 2000 Term Project ID... 2 20 8 400 8000 MEDIE 3 30 7 200 6000 4 15 2 180 2700 Score/10 5 24 TERM221 10 260 6240 Total 139 H 39 H 1280 24940 3000 4000 5000 1000 13,000 Based on the information presented in the above tables, solve the following requirements: Requirment1: Calculate the Predetermined overhead cost? Note: 1- For Electricity & Depreciation use Allocation base Machine hours 2- For Rent & Supervisor salary use the Direct labor Hours fill the above table of MOH based on the Allocation bae given fill the above table of MOH based on the Allocation bae given Reguirment2; calculate the total cost per unit of each dishes served in this restaurant? (Show your work) (Recommended to use Excel DL (Total) DM MOH Total Cost Cost Per Unit Dish#1 Dish#2 Dish#3 Dish#4 Dish#5

Answer rating: 100% (QA)

Step 14 ALLOCATION OF MANUFACTURING OVERHEADMOH ALLOCATED COSTS A B CAB Cost Allocation Base Base Volume Activity Rate 1 Rent 3000 Direct Labor Hour 1... View the full answer