Problem 10-13 Basic Variance Analysis; the Impact of Variances on Unit Costs [LO10-1, LO10-2, LO10-3]
Koontz Company manufactures a number of products. The standards relating to one of these products are shown below, along with actual cost data for May.
Standard Cost per Unit | Actual Cost per Unit | |||||||
Direct materials: | ||||||||
Standard: 1.90 feet at $3.00 per foot | $ |
5.70 |
||||||
Actual: 1.85 feet at $3.40 per foot | $ | 6.29 | ||||||
Direct labor: | ||||||||
Standard: 1.00 hours at $18.00 per hour |
18.00 |
|||||||
Actual: 1.05 hours at $17.40 per hour | 18.27 | |||||||
Variable overhead: | ||||||||
Standard: 1.00 hours at $8.00 per hour | 8.00 | |||||||
Actual: 1.05 hours at $7.60 per hour | 7.98 | |||||||
Total cost per unit | $ |
31.70 |
$ | 32.54 | ||||
Excess of actual cost over standard cost per unit | $ | 0.84 | ||||||
The production superintendent was pleased when he saw this report and commented: “This $0.84 excess cost is well within the 4 percent limit management has set for acceptable variances. It's obvious that there's not much to worry about with this product."
Actual production for the month was 15,000 units. Variable overhead cost is assigned to products on the basis of direct labor-hours. There were no beginning or ending inventories of materials.
Required:
1. Compute the following variances for May:
a. Materials price and quantity variances.
b. Labor rate and efficiency variances.
c. Variable overhead rate and efficiency variances.
2. How much of the $0.84 excess unit cost is traceable to each of the variances computed in (1) above.
3. How much of the $0.84 excess unit cost is traceable to apparent inefficient use of labor time?
In: Accounting
The Economic Order Quantity (EOQ) model is a classical model used for controlling inventory and satisfying demand. Costs included in the model are holding cost per unit, ordering cost and the cost of goods ordered. The assumptions for that model are that only a single item is considered, that the entire quantity ordered arrives at one time, that the demand for the item is constant over time, and that no shortages are allowed.
Suppose we relax the first assumption and allow for multiple items that are independent except for a restriction on the amount of space available to store the products. The following model describes this situation:
Let Dj = | annual demand for item j |
Cj = | unit cost of item j |
Sj = | cost per order placed for item j |
i = | inventory carrying charge as a percentage of the cost per unit |
W = | the maximum amount of space available for all goods |
wj = | space required for item j |
The decision variables are Qj, the amount of item j to order. The model is:
In the objective function, the first term is the annual cost of goods, the second is the annual ordering cost (Dj/Qj is the number of orders), and the last term is the annual inventory holding cost (Qj/2 is the average amount of inventory).
Set up a spreadsheet model for the following data:
Item 1 | Item 2 | Item 3 | |
Annual Demand | 2,500 | 2,500 | 1,500 |
Item Cost ($) | 100 | 50 | 80 |
Order Cost ($) | 165 | 145 | 125 |
Space Required (sq. feet) | 50 | 25 | 40 |
W = $21,000
i = 0.3
Solve the problem using Excel Solver. Hint: You will need to start with decision variable values that are greater than 0 for Solver to find a solution.
If required, round your answers to two decimal places.
Optimal Solution:
Q1 =
Q2 =
Q3 =
If required, round your answer to the nearest dollar. Do not round intermediate calculations.
Total cost = $
In: Operations Management
A person's center of mass is easily found by having the person lie on a reaction board. A horizontal, 3.0-m-long, 6.1kg reaction board is supported only at the ends, with one end resting on a scale and the other on a pivot. A 57kg woman lies on the reaction board with her feet over the pivot. The scale reads 22kg. Assume that the woman doesn't move and a position of her center of mass doesn't change.
What is the distance from the woman's feet to her center of mass?
In: Physics
The accounting department needs to forecast electricity expense for one of the buildings. The data for several months is supplied below. Be careful since the data is listed beginning with the most recent. The forecasting method to be used here is the linear regression. Please round your forecast to the nearest whole number.
Apr 2020: 1463 | Mar 2020: 1372 | Feb 2020: 1087 | Jan 2020: 1316 | Dec 2019: 1346 | Nov 2019: 1224 |
Oct 2019: 1050 | Sep 2019: 1201 | Aug 2019: 1320 | Jul 2019: 1232 | Jun 2019: 1472 | May 2019: 1323 |
Apr 2019: 1490 | Mar 2019: 1464 | Feb 2019: 1147 | Jan 2019: 1208 | Dec 2018: 1471 | Nov 2018: 1085 |
Oct 2018: 1477 | Sep 2018: 1045 | Aug 2018: 1473 | Jul 2018: 1171 | Jun 2018: 1480 | May 2018: 1433 |
Apr 2018: 1369 | Mar 2018: 1157 | Feb 2018: 1079 | Jan 2018: 1095 | Dec 2017: 1127 | Nov 2017: 1445 |
Oct 2017: 1381 |
In: Operations Management
in VBA
What is the major benefit of using Select Case over IF statements? Provide an example of when you would use Select Case.
In: Operations Management
In: Psychology
A 0.24 kg apple falls from a tree to the ground, 4.0m below. Ignore air resistance. Take ground level to be y=0.
A) Determine the apple's kinetic energy, K, the gravitational potential energy of the system, U, and the total mechanical energy of the system, E, when the apple's height above the ground is 4.0 m.
B) Determine the apple's kinetic energy, K, the gravitational potential energy of the system, U, and the total mechanical energy of the system, E, when the apple's height above the ground is 3.0 m.
C) Determine the apple's kinetic energy, K, the gravitational potential energy of the system, U, and the total mechanical energy of the system, E, when the apple's height above the ground is 2.0 m.
D) Determine the apple's kinetic energy, K, the gravitational potential energy of the system, U, and the total mechanical energy of the system, E, when the apple's height above the ground is 1.0 m.
E) Determine the apple's kinetic energy, K, the gravitational potential energy of the system, U, and the total mechanical energy of the system, E, when the apple's height above the ground is 0 m
In: Physics
1) Bob has just finished climbing a sheer cliff above a level beach and wants to figure out how high he climbed. All he has to use is a baseball, a stopwatch, and a friend on the ground below with a long measuring tape. Bob is a pitcher and knows that the fastest he can throw the ball is about ?0=33.7 m/s.Bob starts the stopwatch as he throws the ball, with no way to measure the ball's initial trajectory, and watches carefully. The ball rises and then falls, and after ?1=0.910 s. the ball is once again level with Bob. Bob cannot see well enough to time when the ball hits the ground. Bob's friend then measures that the ball hit the ground ?=125 m. from the base of the cliff.
How high above the beach was the ball when it was thrown?
2) A planet of mass ?=4.05×10^24 kg is orbiting in a circular path a star of mass ?=1.75×10^29 kg. The radius of the orbit is ?=4.35×10^7 km.
What is the orbital period (in Earth days) of the planet ?planet?
Tplanet = days
In: Physics
1. List ALL the different type of network connections involved in the operations for each of the scenarios below. Provide an illustration for each of the scenarios.
Scenarios a. You have just bought a new mobile phone from an online shop. You have decided to take a few snapshots of your best friend and send them to the email account of a mutual friend across the country. b. You are driving around in an unfamiliar city and have just gotten lost. By using your mobile phone’s GPS system, you submit a request for driving directions from a nearby intersection to your destination.
2. Broadcast networks refer to networks such as LANs connected by a technology such as Ethernet. Broadcast networks, by nature, are multiaccess where all routers in a broadcast network can receive a single transmitted packet. Discuss the requirements or deficiencies of a network layer (OSI layer 3 and TCP/IP layer 2) in a broadcast network.
In: Computer Science
Three forces act on an object. the first force is 37.5 lbs at 130.0 degrees, the second force is 28.0 lbs at 30.0 degrees east of south, and the third force is 11.0 lbs due south. What is the net force (magnitude and direction) exerted on this body?
In: Physics
Variable trials refers to a list where each list item is another list of 3 integers between 0 and 9. Imagine each list of 3 integers is a combination of numbers of a lock. Further suppose the variable code refers to a list of three integers that is the correct combination of the lock.
Write a program which, assuming trials and code are already defined, prints out a character for each digit of each trial. Print Y if the digit in the trail matches the digit at the same position in the code. Print # if the digit in the trial does not match the digit at the same position in the code but appears elsewhere in the code. Print N if the digit of the trial does not match the digit in the code and the digit in the trial appears nowhere in the code. Print a newline after the characters after three numbers (for each trial).
Example, if trails = [[2,3,4], [5,5,5], [5,2,3]], and code = [2,3,5], the program output should be:
Y Y N
# # Y
# # #
Hint: the in and not in operators can be used to test whether an item appears in a list.
(language python.)
In: Computer Science
Write an essay on "Interprofessional and collaborative practise" (250 to 300 words)
In: Nursing
In: Psychology
Can a Single Online Respondent Pool Offer a Truly Representative Sample?
Online research programs can often benefit by building samples from multiple respondent pools. Achieving a truly representative sample is a difficult process for many reasons. When drawing from a single source, even if researchers were to use various verification methods, demographic quotas, and other strategies to create a presumably representative sample, the selection methods them- selves create qualitative differences—or allow them to develop over time. The same is true of the parameters under which the online community or respondent pool was formed (subject matter mix, activities, interaction opportunities, etc.). Each online community content site is unique, and members and visitors choose to participate because of the individual experience their preferred site provides. As such, the differences between each site start to solidify as site members share more and more similar experiences and differences within the site’s community decrease. (Think, birds of a feather flock together.)
As such, researchers cannot safely assume that any given online respondent pool offers an accurate probability sample of the adult U.S. or Internet population. Consequently, both intrinsic (personality traits, values, locus of control, etc.) and extrinsic (panel tenure, survey participation rates, etc.) differences will contribute variations to response‐measure distribution across respondent pools. To control distribution of intrinsic characteristics in the sample while randomizing extrinsic characteristics as much as possible, researchers might need to use random selection from multiple respondent pools.
The GfK Research Center for Excellence in New York performed a study to see how the distribution of intrinsic and extrinsic individual differences varied between respondent pools. Respondents were drawn from five different online resource pools, each using a different method to obtain survey respondents. A latent class regression method separated the respondents into five underlying consumer classes according to their Internet‐usage driver profiles.
Researchers then tested which of the intrinsic characteristics tended to appear within the different classes. No variable appeared in more than three classes. Furthermore, the concentration of each class varied considerably across the five respondent pools from which samples were drawn.
Within the classes themselves, variations appeared in their demographic distributions. One of the five experienced a significant skew based on gender, and two other classes exhibited variable age concentrations, with one skewed toward younger respondents and the other toward older ones.
Overall, GfK’s study revealed numerous variations across different respondent resource pools. As their research continues, current findings suggest that researchers must be aware of these trends, especially in choosing their member acquisition and retention strategies and in determining which and how many respondent pools to draw from.
In: Operations Management
In: Operations Management