Job Costs Using Activity-Based Costing
Heitger Company is a job-order costing firm that uses activity-based costing to apply overhead to jobs. Heitger identified three overhead activities and related drivers. Budgeted information for the year is as follows:
| Activity | Cost | Driver | Amount of Driver | ||
| Materials handling | $54,250 | Number of moves | 2,500 | ||
| Engineering | 120,700 | Number of change orders | 8,500 | ||
| Other overhead | 148,500 | Direct labor hours | 45,000 |
Heitger worked on four jobs in July. Data are as follows:
| Job 13-43 | Job 13-44 | Job 13-45 | Job 13-46 | |||||
| Beginning balance | $24,600 | $20,000 | $3,500 | $0 | ||||
| Direct materials | $5,500 | $10,000 | $12,900 | $11,400 | ||||
| Direct labor cost | $830 | $1,080 | $1,510 | $130 | ||||
| Job 13-43 | Job 13-44 | Job 13-45 | Job 13-46 | |||||
| Number of moves | 45 | 49 | 30 | 6 | ||||
| Number of change orders | 31 | 39 | 15 | 23 | ||||
| Direct labor hours | 830 | 1,080 | 1,510 | 130 | ||||
By July 31, Jobs 13-43 and 13-44 were completed and sold. Jobs 13-45 and 13-46 were still in process.
Required:
1. Calculate the activity rates for each of the three overhead activities. Round all activity rates to the nearest cent.
| Materials handling rate | $ per move |
| Engineering rate | $ per change order |
| Other overhead rate | $ per direct labor hour |
2. Prepare job-order cost sheets for each job showing all costs through July 31.
When required, round your answers to the nearest dollar. If an amount is zero, enter "0".
| Heitger Company | ||||
| Job-Order Cost Sheets | ||||
| Job 13-43 | Job 13-44 | Job 13-45 | Job 13-46 | |
| Balance, July 1 | $ | $ | $ | $ |
| Direct materials | ||||
| Direct labor cost | ||||
| Materials handling | ||||
| Engineering | ||||
| Other overhead | ||||
| Total | $ | $ | $ | $ |
3. Calculate the balance in Work in Process on
July 31.
$
4. Calculate the cost of goods sold for
July.
$
5. What if Job 13-46 required no engineering change orders? What is the difference in the new cost of Job 13-46?
$
How would the cost of the other jobs be affected?
In: Accounting
Given the following information on a 30-year fixed-payment fully amortizing loan, determine the owner’s equity in the property after seven years if the market value of the property is $240,000 at the end of year 7: rate: 7%; monthly payment: $1,200.
In: Finance
goal Find the average of the elements in the list (list could
have any number of elements).
If the average is a decimal number, return only the integer part.
Example: if average=10.8, return 10
Example: if list={10, 20, 30, 40, 50}, the method should return:
30
import java.io.*;
import java.util.Scanner;
class Node {
int data;
Node next;
Node(int d){ // Constructor
data = d;
next = null;
}
}
class LinkedList {// a Singly Linked List
Node head; // head of list
public void insert(int data){ // Method to insert a
new node
Node new_node = new Node(data); //
Create a new node with given data
new_node.next = null;
if (head == null) // If the Linked
List is empty, then make the new node as head
head =
new_node;
else {// Else traverse till the
last node and insert the new_node there
Node last =
head;
while (last.next
!= null)
last = last.next;
last.next =
new_node; // Insert the new_node at last node
}
}
}
class Main {
public static void main(String[] args)
{
LinkedList list = new
LinkedList();/* Start with the empty list. */
Scanner scan = new
Scanner(System.in);
int num;
for (int i=0; i<10; i++){//Read
list values
num =
scan.nextInt();
list.insert(num);
}
System.out.println(""+getAvg(list));
}
public static int getAvg(LinkedList list) {
//goal Find the average of the
elements in the list (list could have any number of
elements).
//If the average is a decimal
number, return only the integer part. Example: if average=10.8,
return 10
//Example: if list={10, 20, 30, 40,
50}, the method should return: 30
}
}
In: Computer Science
An investigator analyzed the leading digits from
796796
checks issued by seven suspect companies. The frequencies were found to be
55,
1818,
00,
8989,
224224,
412412,
88,
1717,
and
2323,
and those digits correspond to the leading digits of 1, 2, 3, 4, 5, 6, 7, 8, and 9, respectively. If the observed frequencies are substantially different from the frequencies expected with Benford's law shown below, the check amounts appear to result from fraud. Use a
0.0250.025
significance level to test for goodness-of-fit withBenford's law. Does it appear that the checks are the result of fraud?
|
Leading Digit |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
|
|---|---|---|---|---|---|---|---|---|---|---|
|
Actual Frequency |
55 |
1818 |
00 |
8989 |
224224 |
412412 |
88 |
1717 |
2323 |
|
|
Benford's Law: Distribution of Leading Digits |
30.1% |
17.6% |
12.5% |
9.7% |
7.9% |
6.7% |
5.8% |
5.1% |
4.6% |
Determine the null and alternative hypotheses.
Upper H 0H0:
The leading digits are from a population that conforms to Benford's law.
Upper H 1H1:
At least one leading digit has a frequency that does not conform to Benford's law.
Calculate the test statistic,
chi squaredχ2.
chi squaredχ2equals=nothing
(Round to three decimal places as needed.)
Enter your answer in the answer box and then click Check Answer.
In: Statistics and Probability
match each subsidiary ledger and general ledger post one on each description
In: Accounting
|
Consider the following time series data:
|
||||||||||||||||||||||||||
| - Select your answer -Graph (i)Graph (ii)Graph (iii)Graph (iv)Item 1 | ||||||||||||||||||||||||||
| What type of pattern exists in the data? | ||||||||||||||||||||||||||
| - Select your answer -Positive trend patternHorizontal patternVertical patternNegative trend patternItem 2 | ||||||||||||||||||||||||||
| (b) | Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. | |||||||||||||||||||||||||
| If required, round your answers to two decimal places. Do not round intermediate calculation. | ||||||||||||||||||||||||||
| MSE: | ||||||||||||||||||||||||||
| The forecast for month 8: | ||||||||||||||||||||||||||
| (c) | Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for month 8. | |||||||||||||||||||||||||
| If required, round your answers to two decimal places. Do not round intermediate calculation. | ||||||||||||||||||||||||||
| MSE: | ||||||||||||||||||||||||||
| The forecast for month 8: | ||||||||||||||||||||||||||
| (d) | Compare the three-month moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE? | |||||||||||||||||||||||||
| - Select your answer -3-month moving average exponential smoothingItem 7 | ||||||||||||||||||||||||||
| (e) | Use trial and error to find a value of the exponential smoothing coefficient α that results in the smallest MSE. | |||||||||||||||||||||||||
| If required, round your answer to two decimal places. | ||||||||||||||||||||||||||
| α = |
In: Statistics and Probability
The Attaran Corporation manufactures two electrical products:
portable air conditioners and portable heaters. The assembly
process for each is similar in that both require a certain amount
of wiring and drilling. Each air conditioner takes 3 hours of
wiring and 2 hours of drilling. Each heater must go through 2 hours
of wiring and 1 hour of drilling. During the next production
period, 240 hours of wiring time are available and up to 130 hours
of drilling time may be used. Each air conditioner sold yields a
profit of $20. Each heater assembled may be sold for a $16
profit.
Number of air conditioners to be produced =_____ (round your
response to two decimal places).
Number of heaters to be produced = _______(round your response to
two decimal places).
Optimal solution value = _______(round your response to two
decimal places).
In: Operations Management
Consider the data in the table below.
| Y | X |
| 5 | 8 |
| 10 | 5 |
| 5 | 5 |
| 4 | 9 |
| 1 | 9 |
| 6 | 9 |
| 10 | 5 |
| 9 | 5 |
| 2 | 7 |
| 9 | 8 |
Answer the following questions to two decimal places.
1. The slope coefficient for a regression of Y on X is
2. The constant of a regression of Y on X is
3. The residual for the first observation in the table is
4. The correlation of the residuals and X is
In: Finance
** Use R for the following analysis.
Use the BoneAcid.xlsx data to check what is causing the variation in the acid content in bones among 42 male skeletons from 2 cemeteries. The independent variables included are internment lengths, ages, depths, lime addition and contamination in soil.
Variables/Columns
Burial Site (1 or 2)
Internment Time (Years)
Burial Depth (feet)
LimeAdded (at internment) (1=Yes, 0=No)
Death_Age (Age of Person at the time of death)
Acid Level (g/100g of bone)
Contamination (In soil) (1=Yes, 0=No)
1. Undertake appropriate basic data analytics to motivate the regression model Use dummy variables for each of Burial Site, LimeAdded, and Contamination (If required create the dummy-variables for each).
2. Do you suspect any multicollinearity problem could affect the regression coefficients?
3. Run a regression model of the Acid Level on all independent variables provided and interpret all regression coefficients.
4. Briefly describe what you need to do before conducting any hypothesis testing when you find evidence of heteroscedasticity in an OLS regression model? Test for heteroscedasticity to check for evidence of heteroscedasticity in part 3
5. Test the hypothesis that
i. Beta_InternmentTime < -0.00675
ii. Jointly Beta_BurialSite = Beta_BurialDepth =Beta_LimeAdded=0
6, What is the best model specification that would explain acid content in bones better?
|
Burial Site |
InternmentTime |
Baurial Depth |
LimeAdded |
Death_Age |
Contamination |
Acid Level |
|
1 |
88.5 |
7 |
1 |
34 |
1 |
3.88 |
|
1 |
88.5 |
7 |
1 |
38 |
1 |
4 |
|
1 |
85.2 |
7 |
1 |
27 |
1 |
3.69 |
|
1 |
71.8 |
7.6 |
1 |
26 |
0 |
3.88 |
|
1 |
70.6 |
7.5 |
1 |
42 |
0 |
3.53 |
|
1 |
68 |
7 |
1 |
28 |
0 |
3.93 |
|
1 |
71.6 |
8 |
1 |
35 |
0 |
3.88 |
|
1 |
70.2 |
6 |
1 |
44 |
0 |
3.64 |
|
1 |
55.5 |
6 |
0 |
29 |
0 |
3.97 |
|
1 |
36.5 |
6.5 |
0 |
29 |
0 |
3.85 |
|
1 |
36.3 |
6.5 |
0 |
48 |
0 |
3.96 |
|
1 |
46.5 |
6.5 |
0 |
35 |
0 |
3.69 |
|
1 |
35.9 |
6.5 |
0 |
40 |
0 |
3.76 |
|
1 |
45.5 |
6.5 |
0 |
34 |
0 |
3.75 |
|
1 |
43 |
6.5 |
0 |
38 |
0 |
3.75 |
|
1 |
44.9 |
6.5 |
0 |
27 |
0 |
3.92 |
|
1 |
59.5 |
8 |
0 |
26 |
0 |
3.76 |
|
1 |
58.3 |
8 |
0 |
23 |
0 |
3.93 |
|
1 |
56.5 |
8 |
0 |
35 |
0 |
3.7 |
|
1 |
56.3 |
8 |
0 |
23 |
0 |
3.82 |
|
1 |
43 |
6.5 |
0 |
40 |
0 |
3.78 |
|
1 |
42.5 |
9 |
0 |
31 |
0 |
4 |
|
1 |
29 |
7.5 |
0 |
31 |
0 |
3.92 |
|
1 |
35.3 |
8.5 |
0 |
39 |
0 |
3.79 |
|
2 |
93.6 |
4 |
1 |
39 |
0 |
3.49 |
|
2 |
90 |
4 |
1 |
43 |
0 |
3.57 |
|
2 |
88 |
5.5 |
1 |
26 |
0 |
3.43 |
|
2 |
84.4 |
5 |
1 |
47 |
0 |
3.55 |
|
2 |
84 |
4.75 |
1 |
39 |
0 |
3.5 |
|
2 |
79.7 |
4.75 |
1 |
27 |
0 |
3.27 |
|
2 |
67.4 |
4.5 |
1 |
39 |
0 |
3.66 |
|
2 |
64.7 |
5 |
1 |
27 |
0 |
3.9 |
|
2 |
64.7 |
5.5 |
1 |
35 |
1 |
3.91 |
|
2 |
38.3 |
7 |
0 |
21 |
0 |
3.73 |
|
2 |
59.6 |
9.25 |
0 |
46 |
0 |
3.72 |
|
2 |
32 |
9 |
0 |
24 |
0 |
3.85 |
|
2 |
32.2 |
9 |
0 |
27 |
0 |
3.85 |
|
2 |
26.5 |
7 |
0 |
34 |
0 |
4.06 |
|
2 |
34.7 |
8.5 |
0 |
30 |
0 |
4.04 |
|
2 |
27.6 |
6 |
0 |
22 |
0 |
4 |
|
2 |
35.7 |
9 |
0 |
19 |
0 |
3.93 |
|
2 |
49.6 |
9 |
0 |
50 |
0 |
3.85 |
In: Statistics and Probability
Analysis of Financial Statements: Tying the Ratios Together
The DuPont equation shows the relationships among asset management, debt management, and -Select-liquiditymarketprofitabilityCorrect 1 of Item 1 ratios. Management can use the DuPont equation to analyze ways of improving the firm's performance.
Ratio analysis is important to understand and interpret financial statements; however, sound financial analysis involves more than just calculating and interpreting numbers.
-Select-QuantitativeQualitativeForeignCorrect 2 of Item 1
factors also need to be considered.
Quantitative Problem: Rosnan Industries' 2018 and 2017 balance sheets and income statements are shown below.
| Balance Sheets: | |||
| 2018 | 2017 | ||
| Cash and equivalents | $80 | $65 | |
| Accounts receivable | 275 | 300 | |
| Inventories | 375 | 350 | |
| Total current assets | $730 | $715 | |
| Net plant and equipment | 2,000 | 1,490 | |
| Total assets | $2,730 | $2,205 | |
| Accounts payable | $150 | $85 | |
| Accruals | 75 | 50 | |
| Notes payable | 130 | 155 | |
| Total current liabilities | $355 | $290 | |
| Long-term debt | 450 | 290 | |
| Common stock | 1,225 | 1,225 | |
| Retained earnings | 700 | 400 | |
| Total liabilities and equity | $2,730 | $2,205 | |
| Income Statements: | |||
| 2018 | 2017 | ||
| Sales | $2,000 | $1,500 | |
| Operating costs excluding depreciation | 1,250 | 1,000 | |
| EBITDA | $750 | $500 | |
| Depreciation and amortization | 100 | 75 | |
| EBIT | $650 | $425 | |
| Interest | 62 | 45 | |
| EBT | $588 | $380 | |
| Taxes (40%) | 235 | 152 | |
| Net income | $353 | $228 | |
| Dividends paid | $53 | $48 | |
| Addition to retained earnings | $300 | $180 | |
| Shares outstanding | 100 | 100 | |
| Price | $25.00 | $22.50 | |
| WACC | 10.00% | ||
What is the firm’s 2018 current ratio? Round your answer to two decimal places.
If the industry average debt-to-total-assets ratio is 30%, then
Rosnan’s creditors have a -Select-smallerbiggerCorrect 1 of Item
3 cushion than indicated by the industry average.
What is the firm’s 2018 net profit margin? Round your answer to
four decimal places.
%
If the industry average profit margin is 12%, then Rosnan’s
lower than average debt-to-total-assets ratio might be one reason
for its high profit margin.
-Select-TrueFalseCorrect 1 of Item 4
What is the firm’s 2018 price/earnings ratio? Round your answer to two decimal places.
Using the DuPont equation, what is the firm’s 2018 ROE? Round
your answer to two decimal places.
%
In: Finance