Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The management of TAGAYTAY MOUNTAIN HOTEL is interested in the analysis of the fixed and variable costs in the electricity used in its relationship to
The management of TAGAYTAY MOUNTAIN HOTEL is interested in the analysis of the fixed and variable costs in the electricity used in its relationship to hotel occupancy. The data have been gathered from the books and records in the first six months of 2021: Guestdays Costs 2021 January 1,000 P4,000 February 1,500 5.000 March 2.500 6,000 April 3,000 7,000 May 2,500 6,000 June 4,500 8,000 J. Required computation. Compute for the following, using the method of least square: 31. Variable electricity rate ( round to 5 decimals) 32. Fixed electricity cost per month (round to nearest peso) 33. Coefficient of correlation (round to 5 decimals) 34. Coefficient of determination (round to 5 decimals) 35. Total electricity budget for July, 2021, assuming the hotel expects 2,000 guestdays (round to nearest peso)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started