DoKnow Co. like to estimate the variable and fixed cost components of its maintenance cost and has compiled the following data for the last 6 months of operation: January February March April May June Labor hours Maintenance cost P6,170 5,530 5,230 5,960 190 130 110 180 190 110 6,230 5,320 Answer the following. Show solutions. All answers in two decimal places. 1. Compute for the summation of XY. 2. Compute for the summation of X squared. 3. Using Hi-Lo method, what is the estimated fixed cost per month for maintenance

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question

answer with full solution pls.. 

a down vote will be given if answers are not your own and original and copied from others.

DoKnow Co. like to estimate the variable and fixed cost components of its
maintenance cost and has compiled the following data for the last 6 months of
operation:
January
February
March
April
May
June
Labor hours Maintenance cost
P6,170
5,530
5,230
5,960
6,230
5,320
190
130
110
180
190
110
Answer the following. Show solutions. All answers in two decimal places.
1. Compute for the summation of XY.
2. Compute for the summation of X squared.
3. Using Hi-Lo method, what is the estimated fixed cost per month for maintenance
4. Using the least square method, what is the estimated variable cost per labor hour.
5. If the company will use 230 labor hours in July, what would be the estimated
variable cost per labor hour for maintenance using Hi-Lo method.
6. What is the estimated fixed cost per month for maintenance if least square
method is used?
7. If the company will use 230 hours labor hours in July, what would be the total
predicted cost of maintenance?
8. How much is the total variable cost of maintenance if least square method is used
assuming 150 labor hours is consumed in July?
9. What is the predicted cost of Maintenance for the nonth of July assuming 150
labor hours are consumed if least square method is used.
Transcribed Image Text:DoKnow Co. like to estimate the variable and fixed cost components of its maintenance cost and has compiled the following data for the last 6 months of operation: January February March April May June Labor hours Maintenance cost P6,170 5,530 5,230 5,960 6,230 5,320 190 130 110 180 190 110 Answer the following. Show solutions. All answers in two decimal places. 1. Compute for the summation of XY. 2. Compute for the summation of X squared. 3. Using Hi-Lo method, what is the estimated fixed cost per month for maintenance 4. Using the least square method, what is the estimated variable cost per labor hour. 5. If the company will use 230 labor hours in July, what would be the estimated variable cost per labor hour for maintenance using Hi-Lo method. 6. What is the estimated fixed cost per month for maintenance if least square method is used? 7. If the company will use 230 hours labor hours in July, what would be the total predicted cost of maintenance? 8. How much is the total variable cost of maintenance if least square method is used assuming 150 labor hours is consumed in July? 9. What is the predicted cost of Maintenance for the nonth of July assuming 150 labor hours are consumed if least square method is used.
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Costing Systems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education