Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistical Audit Automation Applying Computer Assisted Audit Techniques

Authors: Edward J. Winslow

1st Edition

1973281015, 978-1973281016

More Books

Students also viewed these Accounting questions