Question: Answer in Microsoft Excel, Please! Case 4 (10 point) One of the points discussed in the Omnibus Bill on Job Creation is related to working

Answer in Microsoft Excel, Please!

Case 4 (10 point) One of the points discussed in the Omnibus Bill on Job Creation is related to working hours regulations. Referring to the working hours in the law which states 8 (eight) hours 1 (one) day and 40 (forty) hours 1 (one) week for 5 (five) working days in 1 (one) week as well as working time overtime which can be done for a maximum of 4 (four) hours in 1 (one) day and 18 (eighteen) hours in 1 (one) week. This will also affect the production unit and the total costs generated. The following information is available: Month January February March April May Production Unit 9.800 8.500 7.000 7.600 8.100 Total Cost (S) 14.740 13.250 11.100 12.000 12.460 Required: a. Determine the cost equation using the high low method. What is the value of the fixed cost and variable cost per unit? b. Regarding the new rules of the Omnibus Bill on Job Creation, you are asked to analyze and provide an explanation regarding cost behavior below which is more suitable to be categorized as a fixed cost, variable cost, or mixed cost: The assumed salary is calculated regularly every month and overtime pay is calculated on an hourly basis. The assumed salary is calculated daily. The assumed salary is calculated on an hourly basis

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Please look at the attachment. It is all written in there.The question is whether to keep the existing machine or to replace it with the new one. This answer has to be supported by calculations of...

Topic Threads Posts Last Post Discussion for Week 1 (Completed) Contains unread posts Locked. Conference Instructions: Each person please make at least one response to one of the posted questions and...

GRADUATE CERTIFICATE IN PROJECT MANAGEMENT PROJ5010: PROJECT PROCUREMENT AND STRATEGIC SOURCING. CASE STUDIES CONTENTS 1. Proj5010: The World Bank RFP Case Study covers 1. Assignment 1: Marks = 5 2....

commentthecaseofKeriChisolm,ofCostaMesa,California.DescribethereasonsforherdisciplineandhowitreflectsonhercompetenceasaCPA. pdf page 19 UPDATE SPRING/SUMMER 2016 ISSUE NO. 81 PRESIDENT'S MESSAGE One...

Chapter One: Valuing Diversity R The wise are as rare as eagles that fly high in the sky. Bantu proverb Managing Workplace Diversity I Chapter One: Valuing Diversity VALUING DIVERSITY Chapter...

hi. I'm stuck with a report whose Chic Paints Ltd. and I am finding difficulty to answer some questions such as the organisations accounting system requirements including hardware and software...

write a 3-5 sentence summery about the main arguments of the text Introduction: "My happy supportive smile is running out" On November 10, 2004, an open letter posted to a blog titled "EA: The Human...

GOOD DAY MY BEST WRITER ATTACHED HERE IS MY INT 620 FINAL PROJECT ,I AM ALSO ATTACHING WHAT I HAVE WRITTEN ON HISTORIC BACKGROUND, MILESTONE ONE ,AND MILESTONE TWO FOR YOU TO COMBINED UPGRADE AND DO...

7 Writing in the Workplace If writing must be a precise form of communication, it should be treated like a precision instrument. It should be sharpened, and it should not be used carelessly. Theodore...

s) Topics: 1. Intelligent Technology in Communication 2. Ethical and Legal Communication Following points are mandatory: Ensure your presentation is visually appealing with both images and text. ...

What is the advantage of a prepayment penalty mortgage from the perspective of the lender?

34. The following table shows the probabilities of blood types in the general population (Hoxworth Blood Center, Cincinnati, Ohio, March 2003). a. What is the probability a person will have type O...

When considering all university athletic teams in 2 0 2 0 - 2 0 2 1 , men represented what percent of the head coaches? Group of answer choices 5 0 % 7 5 % 8 5 % 9 0 %

The text lists numerous suggestions for how to prevent accidents. Based on what you know about the Texas City explosion, what do you say Texas City tells you about the most important three steps an...

15-2 With government policies like this, how do you think French companies remain competitive with those, say, in the United States?

1 If you were a high-level administrator at a university what difficulties might you expect to find in implementing this balanced scorecard approach? Publicly funded universities face pressure to...