DataSpan, Inc., automated its plant at the start of the current year and installed a flexible manufacturing system. The company is also evaluating its suppliers and moving toward Lean Production. Many adjustment problems have been encountered, including problems relating to performance measurement. After much study, the company has decided to use the performance measures below, and it has gathered data relating to these measures for the first four months of operations.

Management has asked for your help in computing throughput time, delivery cycle time, and MCE. The following average times have been logged over the last four months:

John Fleming, chief administrator for Valley View Hospital, is concerned about the costs for tests in the hospital’s lab. Charges for lab tests are consistently higher at Valley View than at other hospitals and have resulted in many complaints. Also, because of strict regulations on amounts reimbursed for lab tests, payments received from insurance companies and governmental units have not been high enough to cover lab costs.

Mr. Fleming has asked you to evaluate costs in the hospital’s lab for the past month. The following information is available:

Two types of tests are performed in the lab—blood tests and smears. During the past month, 1,800 blood tests and 2,400 smears were performed in the lab.

Small glass plates are used in both types of tests. During the past month, the hospital purchased 12,000 plates at a cost of $56,400. 1,500 of these plates were unused at the end of the month; no plates were on hand at the beginning of the month.

During the past month, 1,150 hours of labor time were recorded in the lab at a cost of $21,850.

The lab’s variable overhead cost last month totaled $7,820.

Valley View Hospital has never used standard costs. By searching industry literature, however, you have determined the following nationwide averages for hospital labs:

Plates: Two plates are required per lab test. These plates cost $5.00 each and are disposed of after the test is completed.

Labor: Each blood test should require 0.3 hours to complete, and each smear should require 0.15 hours to complete. The average cost of this lab time is $20 per hour.

Overhead: Overhead cost is based on direct labor-hours. The average rate for variable overhead is $6 per hour.

Required:

1. Compute a materials price variance for the plates purchased last month and a materials quantity variance for the plates used last month.

2. For labor cost in the lab:

a. Compute a labor rate variance and a labor efficiency variance.

b. In most hospitals, one-half of the workers in the lab are senior technicians and one-half are assistants. In an effort to reduce costs, Valley View Hospital employs only one-fourth senior technicians and three-fourths assistants. Would you recommend that this policy be continued?

3-a. Compute the variable overhead rate and efficiency variances.

3-b. Is there any relation between the variable overhead efficiency variance and the labor efficiency variance?

QUESTION# 4      ( 20marks)

Marc Goudreau, administrator of Clearwater Hospital, was puzzled by the prior month's reports. “Every month, it's anyone's guess whether the lab will show a profit or a loss. Perhaps the only answer is to increase our lab fees again.”

“We can't,” replied Rhoda Groves, the controller. “There are still a lot of complaints about the last increase, particularly from the insurance companies and government health units. They are now paying only about 80% of what we bill. I'm beginning to think the problem is on the cost side.”

To determine if the Clearwater lab costs are in line with those of other hospital labs, Goudreau has asked you to evaluate the costs for the past month. Groves has provided you with the following information:

Two basic types of tests are performed in the lab—smears and blood tests. During the past month, 2,700 smears and 900 blood tests were performed in the lab.

Small glass plates are used in both types of tests. During the past month, the hospital purchased 16,000 plates at a cost of $38,400. This cost is net of a 4% purchase discount. A total of 2,000 of these plates were unused at the end of the month; no plates were on hand at the beginning of the month.

During the past month, 1,800 hours of labour time were used in performing smears and blood tests. The cost of this labour time was $18,450.

The lab's variable overhead cost last month totalled $11,700.

Fixed overhead cost last month totalled $10,400.

Clearwater Hospital has never used standard costs. By searching industry literature, however, you have determined the following nationwide averages for hospital labs:

Plates: Three plates are required per lab test. These plates cost $2.50 each and are disposed of after the test is completed.

Labour: Each smear should require 0.3 hours to complete, and each blood test should require 0.6 hours to complete. The average cost of this lab time is $12 per hour.

Required:

Compute the Materials Price Variance for the plates purchased last month, and compute a Materials Quantity Variance for the plates used last month.

For Labour Cost in the lab:

Compute a Labour Rate Variance and a Labour Efficiency Variance.

In most hospitals, three-quarters of the workers in the lab are certified technicians and one-quarter are assistants. In an effort to reduce costs, Clearwater Hospital employs only one-half certified technicians and one-half assistants. Would you recommend that this policy be continued? Explain.

1.Markham Company makes two products: Basic Product and Deluxe Product. Annual production and sales are 1,800 units of Basic Product and 1,400 units of Deluxe Product. The company has traditionally used direct labor-hours as the basis for applying all manufacturing overhead to products. Basic Product requires 0.3 direct labor hours per unit and Deluxe Product requires 0.6 direct labor hours per unit. The total estimated overhead for next period is $99,585.

The company is considering switching to an activity-based costing system for the purpose of computing unit product costs for external reports. The new activity-based costing system would have three overhead activity cost pools—Activity 1, Activity 2, and General Factory—with estimated overhead costs and expected activity as follows:

(Note: The General Factory activity cost pool's costs are allocated on the basis of direct labor hours.)

The predetermined overhead rate (i.e., activity rate) for Activity 2 under the activity-based costing system is closest to:

a. $8.20.

b. $46.32.

c. $72.16.

d. $9.79.

2.South Beach Industries reports the following information about resources. At the beginning of the year, South Beach estimated it would spend $296,300 for materials, $48,500 for purchasing, $32,300 for setups, and $45,000 for repairs.

Compute unused resource capacity for repairs for South Beach.

a. $4,900.

b. $9,000.

c. $4,100.

d. $3,900.

3. The manufacturing overhead budget at Levetron Corporation is based on budgeted direct labor-hours. The direct labor budget indicates that 7,700 direct labor-hours will be required in August. The variable overhead rate is $9.20 per direct labor-hour. The company's budgeted fixed manufacturing overhead is $143,990 per month, which includes depreciation of $25,640. All other fixed manufacturing overhead costs represent current cash flows. The company recomputes its predetermined overhead rate every month. The predetermined overhead rate for August should be:

a.$9.20.

b. $27.90.

c.$24.57.

d.$18.70.

John Fleming, chief administrator for Valley View Hospital, is concerned about the costs for tests in the hospital’s lab. Charges for lab tests are consistently higher at Valley View than at other hospitals and have resulted in many complaints. Also, because of strict regulations on amounts reimbursed for lab tests, payments received from insurance companies and governmental units have not been high enough to cover lab costs. Mr. Fleming has asked you to evaluate costs in the hospital’s lab for the past month. The following information is available: Two types of tests are performed in the lab—blood tests and smears. During the past month, 1,800 blood tests and 2,400 smears were performed in the lab. Small glass plates are used in both types of tests. During the past month, the hospital purchased 12,000 plates at a cost of $56,400. 1,500 of these plates were unused at the end of the month; no plates were on hand at the beginning of the month. During the past month, 1,150 hours of labor time were recorded in the lab at a cost of $21,850. The lab’s variable overhead cost last month totaled $7,820. Valley View Hospital has never used standard costs. By searching industry literature, however, you have determined the following nationwide averages for hospital labs: Plates: Two plates are required per lab test. These plates cost $5.00 each and are disposed of after the test is completed. Labor: Each blood test should require 0.3 hours to complete, and each smear should require 0.15 hours to complete. The average cost of this lab time is $20 per hour. Overhead: Overhead cost is based on direct labor-hours. The average rate for variable overhead is $6 per hour. Required: 1. Compute a materials price variance for the plates purchased last month and a materials quantity variance for the plates used last month. 2. For labor cost in the lab: a. Compute a labor rate variance and a labor efficiency variance. b. In most hospitals, one-half of the workers in the lab are senior technicians and one-half are assistants. In an effort to reduce costs, Valley View Hospital employs only one-fourth senior technicians and three-fourths assistants. Would you recommend that this policy be continued? 3-a. Compute the variable overhead rate and efficiency variances. 3-b. Is there any relation between the variable overhead efficiency variance and the labor efficiency variance?

A student conducted an experiment to determine what factors are important in the rate of a reaction between potassium carbonate and hydrochloric acid. The student diluted 2.000 mL of 4.000 M K2CO3 to 75.00 mL, then combined that solution with 75.00 mL of 2.000 M HCl.

The student tabulated the amount of CO2 gas collected over time and recorded the results in the columns to the left.

1. Use a rearrangement of PV = nRT to solve for the number of moles of CO2 produced. You may assume atmospheric pressure and room temperature. Enter (and fill down) your formula in column C.

This is suppose to be an excel file bt i do not know how to manipulate the formula where I can put it into excel and what information to extract from the problem to use in order to help solve the problem.

HELP PLEASE !!

Problem 11-14 Measures of Internal Business Process Performance [LO11-3]

Course Learning Outcomes-Covered
• Identify and analyze different perspectives on understanding problems for different situations. (3.1)
• Utilize different decision making tools to enhance problem solving and decision making approaches.   (4.3)
• Identify organized alternatives and select among possible alternative to evaluate business options. (2.10)
• Create a Decision Making and Problem Solving worksheet document. (4.5)

Critical Thinking Questions: (Marks 5)

Question 1: (1 Mark)
Suppose you are a member of a group asked to find ways to cut costs throughout your organization for the upcoming year. Sales have fallen sharply, and the company is in danger of going out of business. After gathering information, your group concludes that the company will save the most money by freezing pay for a year, despite a tradition of annual salary increases. How can you make sure this is a fair decision? How can you make sure that others in the organization will see it as a fair decision?

Question 2: Case Analysis
Care, a health consultancy company in Saudi Arabia, is studying the economic benefits of a program of preventative COVID-19 flu vaccinations. Care has to give advice to government for COVID-19 vaccination. If vaccinations are not introduced then the estimated cost to the government if flu strikes in the next year is SR.70m with probability 0.1, SR.100m with probability 0.3 and SR.150m with probability 0.6. It is estimated that such a program will cost SR.70m and that the probability of flu striking in the next year is 0.75.
One alternative open to the committee is to institute an "early-warning" monitoring scheme (costing SR.30m) which will enable it to detect an outbreak of flu early and hence institute a rush vaccination program (costing SR.100m because of the need to vaccinate quickly before the outbreak spreads).
    Question
• As a consultant of Care, Develop a decision tree for alternatives and make recommendation to Indian government that which alternative can maximize expected economic benefits?

Question 3: (1 Mark)
Decision support tools rely on objective, mathematical data. What part does ethics play in using decision support software?

Question 4: (1 Mark)
If you collect too much information for analyzing a decision, you can suffer from analysis paralysis, where you spend too much time thinking about a decision rather than making one. Recall a major financial decision you made recently, such as of a car or housing purchase or rental. Describe your process for making the decision. How could analysis paralysis have affected this process?