Problem Solving: The Blue mountains Snow Hotels accommodation in New South Wales has 100 rooms, as the winter season is around the corner the DOSM is planning for the season start. The management is keen to know how many rooms should be booked for the 7-NIGHT from 16'" June till 22"[1 June 2023 with a desired target profit of $6000 to break even. The rooms are priced to sell $199 per night. The DOSM requires you to prepare a report calculating the BEP for the period also to analyse and categorize costs according to their behaviour differentiate cost related to pricing and cost control techniques according to the various cost drivers and behaviours the costs that can be controlled and reduced to make more yield by not compromising on service. Estimated expenses From 16th June 22"'1 June 2023 Casual employees' wages 5 3,000.00 Electricity S 3,000.00 Full time wages to employees 5 14,000.00 Internet charges for the period S 242.00 Laundry and dry~cleaning expenses S 60000 Marketing Charges S 200.00 Public Liability Insurance S 400.00 Super Annuation S 2,310.00 Telephone expenses 5 80.00 Waste removal charges S 300.00 Water Expenses S 800.00 The requirement of the report are as follows: Required: 1. Cost Analysis: (Here you must differentiate cost as fixed cost / variable cost and state the reason why you believe they are fixed [variablel (750 1000words) (10 Marks) 2. BEP Calculations: Calculate and suggest the Break Even point with the provided information. The DOSM would like to Know the BEP in dollars, rooms and occupancy percentage for the seven nights (remember to calculate for the whole 7 nights) (15 Marks] 3. Report Presentation with no errors is awarded (5 marks[ (you can use Microsoft excel to work on your assignment calculation part and import it to Microsoft word when writing your report. Please use proper referencing where needed using APA style. Please follow the below format to complete your report Failing to do so would not be awarded the presentation marks) Further Instructions: 1. Your assignment must be submitted no later than the Sunday ending week 6 ( 11:59 PM.) Assessment tasks submitted after the due date, without prior approval or arrangement, will be penalised by ten percent. Requests for extension of time must be made with your lecturer and based on Special Consideration guidelines using the special consideration form. 2. It is preferred you do your assignment using Microsoft word 3. This assignment must be handed in for successful completion of the course and will count as 30 marks towards the final mark. 4. All assignments are to be uploaded to the Turnitin link Your report should be in this format: Contents Page: A. Overview (100 150 words) 5. Body of the Report (total 30 Marks) (body of the report should comprise of the following) 1. Cost Analysis: (Here you must differentiate cost as fixed cost / variable cost and state the reason why you believe they are fixed [variablel (750 . 1000words) (10 Marks) 2. BEP Calculations: Calculate and suggest the Break Even point with the provided information. The DOSM would like to Know the BEP in dollars, rooms and occupancy percentage (15 Marks) 3. Report Presentation with no errors is awarded (5 marks) (you can use Microsoft excel to work on your assignment calculation part and import it to Microsoft word when writing your report. Please use proper referencing where needed using APA style. Please follow the below format to complete your report- Failing to do so would not be awarded the presentation marks)