Pasta Bowl is a chain of restaurants which operates accross the UK. Below is Pasta Bowl's actual expenditure, across eight cost centres. Analysis of past expenditure patterns indicate that variable costs in some centres vary according to the number of restaurants (NR) while others vary according to the number of seats occupied (NS). The actual expenditure for the year ended 30 September 2022 is shown below; The business operates an incremental budgeting system. The previous year's actual expenditure is adjusted for the impact of anticipated changes in volumes and costs. You have been asked to help prepare the budget for the year to 30 September 2023 and you have gathered the following information; (i) Total fixed costs in the year to 30 September 2022 were 1,677,500. These were incurred by Advertising and Promotion charges (1,200,000), Maintenance (227,500) and Head Office Staff Costs (250,000). (ii) Some restaurants were closed temporarily due to COVID, as a result of this some pizza ovens required replacing. On the on 1st October 2022 twenty pizza ovens were purchased, costing ,3000 each. The ovens have expected useful economic lives of 5 years and no residual value. The old diesel ovens were scrapped. The cost of the ovens should be assigned to the Maintenance centre. (iii) Due to the significant revenue fall in 2021 and 2022 from COVID, Pasta Bowl have had to reduce their cost base on Food and Beverages. They have appointed a new food and beverage contractor to undertake activities with effect from 1st October 2022 . The contracted price of 43.20 per occupied seat plus a fixed fee of 400,000 p.a is payable quarterly in arrears. (iv) Cleaning materials have inflated due to supply chain issues and hence have increased by 0.05 per occupied seat. (v) All other costs and expected to increase in line with inflation of 6% p.a. (vi) Due to COVID there was a reduction in sales last year, so volumes of both NR and NS are expected to increase by 35%. (vii) There is little seasonal variation in volumes during the year so the budget is phased evenly for each month. It is now November 2022. The actual volumes and costs for October 2022 have been reported and are shown below: The following information below has been added to explain the large increase in costs: (i) Due to the significant losses reported at the end of the financial year, a new CEO has been appointed, which has increased the Head office Staff Costs ii) Utilities have increased due to the significant rise in oll and gas prices (iii) Advertising and Marketing has significantly increased due to it's television advertising campaign. Currently TV is is Pasta Bowls main medium to advertise. Requirements The following information below has been added to explain the large increase in costs: (i) Due to the significant losses reported at the end of the financial year, a new CEO has been appointed, which has increased the Head office Staff Costs ii) Utilities have increased due to the significant rise in oil and gas prices (iii) Advertising and Marketing has significantly increased due to it's television advertising campaign. Currently TV is is Pasta Bowls main medium to advertise. Requirements (1) Using MS Excel build a budgeting model in accordance with good spreadsheet design principles, for the financial year ended September 2023. As per the student template all numbers should be rounded to the nearest whole number, the exception 'VC per unit' being 2dp. (2) In the same MS Excel file create a worksheet and build a variance report for Oct-2022 showing the budget, actual and variances for all cost centres. As per the student template all numbers should be rounded to the nearest whole number, the exception 'VC per unit' being 2dp. (3) The Senior Management of Pasta Bowl have reviewed the Variance Report and are concerned about the adverse variances. Write a 250 word email (+/10%) to the MD including: - a brief explanation of a variance report - Identify and explain the cause of two adverse variances - Make appropriate recommendations to reduce these variances (4) The Senior Management of Pasta Bowl have reviewed Go's Variance Report and are concerned about the adverse variances. They want to improve their visibility on cost and therefore want a better budgetary system. They are looking for a new budget system whereby budget owners will need to justify each cost to senior management. Requirement Prepare a 5 min video, recommending a new budget type for Pasta Bowl. Describe two advantages and two disadvantages. (You can use your phone/ computer to record the clip, and then upload) NOTE 1 - The marker will stop watching the recording at the five minute mark. NOTE 2 - Instructions on how to record and submit the video can be found in Studynet under the assignment information CW1 Unit. Refer to the 'Rubix' for further details and to understand how marks will be awarded. Pasta Bowl is a chain of restaurants which operates accross the UK. Below is Pasta Bowl's actual expenditure, across eight cost centres. Analysis of past expenditure patterns indicate that variable costs in some centres vary according to the number of restaurants (NR) while others vary according to the number of seats occupied (NS). The actual expenditure for the year ended 30 September 2022 is shown below; The business operates an incremental budgeting system. The previous year's actual expenditure is adjusted for the impact of anticipated changes in volumes and costs. You have been asked to help prepare the budget for the year to 30 September 2023 and you have gathered the following information; (i) Total fixed costs in the year to 30 September 2022 were 1,677,500. These were incurred by Advertising and Promotion charges (1,200,000), Maintenance (227,500) and Head Office Staff Costs (250,000). (ii) Some restaurants were closed temporarily due to COVID, as a result of this some pizza ovens required replacing. On the on 1st October 2022 twenty pizza ovens were purchased, costing ,3000 each. The ovens have expected useful economic lives of 5 years and no residual value. The old diesel ovens were scrapped. The cost of the ovens should be assigned to the Maintenance centre. (iii) Due to the significant revenue fall in 2021 and 2022 from COVID, Pasta Bowl have had to reduce their cost base on Food and Beverages. They have appointed a new food and beverage contractor to undertake activities with effect from 1st October 2022 . The contracted price of 43.20 per occupied seat plus a fixed fee of 400,000 p.a is payable quarterly in arrears. (iv) Cleaning materials have inflated due to supply chain issues and hence have increased by 0.05 per occupied seat. (v) All other costs and expected to increase in line with inflation of 6% p.a. (vi) Due to COVID there was a reduction in sales last year, so volumes of both NR and NS are expected to increase by 35%. (vii) There is little seasonal variation in volumes during the year so the budget is phased evenly for each month. It is now November 2022. The actual volumes and costs for October 2022 have been reported and are shown below: The following information below has been added to explain the large increase in costs: (i) Due to the significant losses reported at the end of the financial year, a new CEO has been appointed, which has increased the Head office Staff Costs ii) Utilities have increased due to the significant rise in oll and gas prices (iii) Advertising and Marketing has significantly increased due to it's television advertising campaign. Currently TV is is Pasta Bowls main medium to advertise. Requirements The following information below has been added to explain the large increase in costs: (i) Due to the significant losses reported at the end of the financial year, a new CEO has been appointed, which has increased the Head office Staff Costs ii) Utilities have increased due to the significant rise in oil and gas prices (iii) Advertising and Marketing has significantly increased due to it's television advertising campaign. Currently TV is is Pasta Bowls main medium to advertise. Requirements (1) Using MS Excel build a budgeting model in accordance with good spreadsheet design principles, for the financial year ended September 2023. As per the student template all numbers should be rounded to the nearest whole number, the exception 'VC per unit' being 2dp. (2) In the same MS Excel file create a worksheet and build a variance report for Oct-2022 showing the budget, actual and variances for all cost centres. As per the student template all numbers should be rounded to the nearest whole number, the exception 'VC per unit' being 2dp. (3) The Senior Management of Pasta Bowl have reviewed the Variance Report and are concerned about the adverse variances. Write a 250 word email (+/10%) to the MD including: - a brief explanation of a variance report - Identify and explain the cause of two adverse variances - Make appropriate recommendations to reduce these variances (4) The Senior Management of Pasta Bowl have reviewed Go's Variance Report and are concerned about the adverse variances. They want to improve their visibility on cost and therefore want a better budgetary system. They are looking for a new budget system whereby budget owners will need to justify each cost to senior management. Requirement Prepare a 5 min video, recommending a new budget type for Pasta Bowl. Describe two advantages and two disadvantages. (You can use your phone/ computer to record the clip, and then upload) NOTE 1 - The marker will stop watching the recording at the five minute mark. NOTE 2 - Instructions on how to record and submit the video can be found in Studynet under the assignment information CW1 Unit. Refer to the 'Rubix' for further details and to understand how marks will be awarded