you can do it as word file as well

it is accounting question

For this assignment please use the posted excel spreadsheet labelled as Assignment 4" and answer the following questions from Q 1. - 4. (Marks: 4). Q1. Complete the store room inventory valuations for Barnaby's Hideaway and obtain a total inventory figure, using the posted excel spreadsheet. Q2. Using the inventory value you calculated in Q 1. As a closing inventory, obtain a cost of food sold using the following data: Opening inventory, $5,320.00 Purchasing, $24,560.00 Cooking liquor, $183.00 Food to bar, $75.60 Steward sales, $365.50 Promotion expense, $87.30 Cost of employees' meals, $1,365.00. Q3. Given the cost of food sold calculated in Q2, calculate the food cost percent for Barnaby's Hideaway, assuming food sales are $66,419.15. Q4. Calculate inventory turnover for Barnaby's Hideaway using figures you calculated in Q2. Q5. The following format has been illustrated in chapter 9 at Figure 9.2, use the following information to determine food cost, food sales, and food cost percent today and to date for the Diner for the first four days of May (Marks: 2). Adjustments Date Directs in $ Stores in $ Sales in s Added to Cost in s 5/1 5/2 573 5/4 350 250 135 75 350 175 125 135 0 25 0 10 Subtracted from Cost in $ 0 0 10 20 1.400 1.000 1.000 500 For this assignment please use the posted excel spreadsheet labelled as Assignment 4" and answer the following questions from Q 1. - 4. (Marks: 4). Q1. Complete the store room inventory valuations for Barnaby's Hideaway and obtain a total inventory figure, using the posted excel spreadsheet. Q2. Using the inventory value you calculated in Q 1. As a closing inventory, obtain a cost of food sold using the following data: Opening inventory, $5,320.00 Purchasing, $24,560.00 Cooking liquor, $183.00 Food to bar, $75.60 Steward sales, $365.50 Promotion expense, $87.30 Cost of employees' meals, $1,365.00. Q3. Given the cost of food sold calculated in Q2, calculate the food cost percent for Barnaby's Hideaway, assuming food sales are $66,419.15. Q4. Calculate inventory turnover for Barnaby's Hideaway using figures you calculated in Q2. Q5. The following format has been illustrated in chapter 9 at Figure 9.2, use the following information to determine food cost, food sales, and food cost percent today and to date for the Diner for the first four days of May (Marks: 2). Adjustments Date Directs in $ Stores in $ Sales in s Added to Cost in s 5/1 5/2 573 5/4 350 250 135 75 350 175 125 135 0 25 0 10 Subtracted from Cost in $ 0 0 10 20 1.400 1.000 1.000 500