Answers
Answer 1:
Kindly note: In the format the first row was without a row header. I assume it is expected to be filled up. Hence I have given the 'units to be produced' in this table since these data are required for the calculations. In case this row (first row) is not expected to be filled up, you may not fill in content of first row.
For formulas, the above excel with 'show formula' is as below:
Answer 2:
Overtime hours for 2nd and 3rd quarters are zero since available regular hours are higher than direct labor hours required.
Kindly note: In the format the first row was without a row header. I assume it is expected to be filled up.
Hence I have given the 'units to be produced' in this table since these data are required for the calculations. In case this row (first row) is not expected to be filled up, you may not fill the content of first row.
For formulas, the above excel with 'show formula' is as below:
Rordan Corporation Direct Labor Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Units to be produced 39,200 11,200 8,500 8,600 10,900 Direct Labor time per unit (hours) 0.55 0.55 0.55 0.55 0.55 Total direct labor hours needed 4,675 4,730 21,560 6,160 $16.00 5,995 $16.00 $74,800 $16.00 $16.00 $95,920 $344,960 $16.00 Direct labor cost per hour $98,560 $75,680 Total direct labor cost
A В C F Rordan Corporation Direct Labor Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year 1 2 3 4 Units to be produced 11200 8500 8600 10900 39200 0.55 0.55 0.55 Direct Labor time per unit (hours) 0.55 0.55 5 -D4*D5 -E4*E5 -F4*F5 Total direct labor hours needed =B4*B5 -C4 C5 6 7 Direct labor cost per hour 16 16 16 16 16 -D6*D7 =E6*E7 =F6* F7 -C6*C7 8 Total direct labor cost -В6*B7 9
Rordan Corporation Direct Labor Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Units to be produced 11,200 8,500 10,900 8,600 39,200 Direct Labor time per unit (hours) 0.55 0.55 0.55 0.55 0.55 Total direct labor hours needed 6,160 4,730 5,995 4,675 21,560 5,900 5,900 23,600 Regular hours Overtime hours 5,900 5,900 260 0 0 95 355 $94,400 $377,600 Wages for regular hours Overtime wages $94,400 $94,400 $94,400 $8,520 6,240 2,280 $96,680 $386,120 $100,640 $94,400 $94,400 Total direct labor cost
A В Е F Rordan Corporation Direct Labor Budget 1 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year 3 4 Units to be produced 11200 8600 39200 8500 10900 Direct Labor time per unit (hours) 0.55 0.55 0.55 0.55 5 0.55 -B4*B5 -E4*E5 -F4*F5 Total direct labor hours needed -C4*C5 -D4*D5 6 7 Regular hours 8 Overtime hours 9 Wages for regular hours 10 Overtime wages 5900 =SUM(B7:E7) -SUM(B8:E8) =SUM(B9:E9) -D8*16*1.5-E8*16*1.5 SUM(B10:E10) 5900 5900 5900 |-В6-B7 -E6-E7 -E7*16 0 -B7*16 -C7*16 ED7 16 -B8*16*1.5C8*16*1.5 -C9+C10 -B9+B10 -E9+E10 =F9+F10 11 Total direct labor cost D9+D10 12
.
Similar Solved Questions
1 answer
A mathematical conjecture states that if we start with any positive number we can get to the value 1 by repeating 2 poss...
A mathematical conjecture states that if we start with any positive number we can get to the value 1 by repeating 2 possible steps depending on the value of the current number. If the current value is even we divide the number by 2 and reapply the steps again (number / 2). If the number is odd we mu...
1 answer
After a revolution, the economy of Zurka has changed significantly. Compared to the previous year, productivity...
After a revolution, the economy of Zurka has changed significantly. Compared to the previous year, productivity has fallen by half while prices have doubled. Which of the following statements is most accurate: There is no effect on the well-being of the economy because the changes cancel each other ...
1 answer
I have to write a speech of a business nature about creating more interest in and understanding of the American business enterprise
I have to write a speech of a business nature about creating more interest in and understanding of the American business enterprise.Im confused on what this means. Could someone help me?????????????...
1 answer
Binary Search Trees (a) 5 pointsl Insert 5, 12, 7, 1, 6, 3, 13, 2, 10,...
Binary Search Trees (a) 5 pointsl Insert 5, 12, 7, 1, 6, 3, 13, 2, 10, 11 into an empty binary search tree in the given order. Show the resulting BST after every insertion. (b) 5 points) What are the preorder, inorder, and postorder traversals of the BST you have after (a)? (c) 5 points Delete 2, 7...
1 answer
Theory Electric field is a measure of the degree to which a source charge Q distorts...
Theory Electric field is a measure of the degree to which a source charge Q distorts its surrounding space. As a result of this distortion, the motion of other charges q are driven by the electric force Fe the source charge exerts on them. In this regard, electric field is defined as the ratio of th...
1 answer
Required information [The following information applies to the questions displayed below.] Gabi Gram started The Gram...
Required information [The following information applies to the questions displayed below.] Gabi Gram started The Gram Co., a new business that began operations on May 1. The Gram Co. completed the following transactions during its first month of operations. May 1 G. Gram invested $42,000 cash i...
1 answer
Case presentation Jane remembers feeling very hot, stressed and confined in her car on the expressway...
Case presentation Jane remembers feeling very hot, stressed and confined in her car on the expressway as she was on her way down to an important meeting. “I was getting very agitated because the traffic was at a standstill and I only had just over an hour to get there. I knew I wasn’t go...
1 answer
How do you find the roots, real and imaginary, of #y=(x-5)(-7x-2)# using the quadratic formula?
How do you find the roots, real and imaginary, of #y=(x-5)(-7x-2)# using the quadratic formula?...
1 answer
Which of the following statements is true? a New technologies that reduce production costs, and thus...
Which of the following statements is true? a New technologies that reduce production costs, and thus the price of the good, will spread rapidly throughout the industry as a result of competition. b “Creative destruction” occurs when new goods and production methods make firms that are no...
1 answer
Chapter 42 Transport in mammals 1. What is the primary cause of the low velocity of...
Chapter 42 Transport in mammals 1. What is the primary cause of the low velocity of blood flow through the capillaries? 2. How does increasing blood pressure by increasing cardiac output combined with diverting most blood flow to the skeletal muscles prepare the body to confront or flee danger 3. Ex...
1 answer
Two price-taking firms compete by setting quantities of output, then Select one: O a marginal revenue...
two price-taking firms compete by setting quantities of output, then Select one: O a marginal revenue is the same as the market price. b. social surplus will be maximized. O c. the market price will be climater than marginal cost. Od they will produce the same amount of output as in perfect competit...
1 answer
Tabe 4.1 Price per pizza Quantity demanded (pizzas per month) Quantity supplied (pizzas per month) $6...
Tabe 4.1 Price per pizza Quantity demanded (pizzas per month) Quantity supplied (pizzas per month) $6 1,000 900 800 700 600 700 750 800 $8 $10 850 $12 900 11. Refer to Table 4.1. If the price per pizza is $10, the price will a. remain constant because the market is in equilibrium. b. increase becaus...
1 answer
In a previous year, 56% of females aged 15 and older lived alone. A sociologist tests...
In a previous year, 56% of females aged 15 and older lived alone. A sociologist tests whether this percentage is different today by conducting has changed? random sample of 700 females aged 15 and older and finds that 401 are living alone. Is there sufficient evidence at the a=0.1 level of significa...
1 answer
#2 An investment under consideration has a payback of six years and a cost of $573,000....
#2 An investment under consideration has a payback of six years and a cost of $573,000. If the required return is 12 percent, what is the worst-case NPV? The best-case NPV? Explain. Assume the cash flows are conventional. De 1 of 1...
1 answer
3. The following graph illustrates a monopoly market. MC = ATC Output The government intervenes in...
3. The following graph illustrates a monopoly market. MC = ATC Output The government intervenes in the market and regulates the monopolist to charge the perfectly competitive market price. That is, regulation forces the monopoly firm to behave as if it was a perfectly competitive firm. a. What price...
1 answer
. A square piece of alumininum with as mass of 5.4 has a l length of...
. A square piece of alumininum with as mass of 5.4 has a l length of 2 em and a thickness of 5 mm. What is the density of the piece of aluminium in·[/ A ball is thrown into the air with a velocity of Sm/s from on top of a 36 m building. How long does it take the ball to hit the ground? 10. If...