PA9-1 Calculating Direct Material, Direct Labor, Variable Overhead Variances [LO 9-3, 9-4, 9-5]
Barley Hopp, Inc., manufactures custom-ordered commemorative
beer steins. Its standard cost information follows:
| Standard Quantity | Standard Price (Rate) | Standard Unit Cost | ||||||
| Direct materials (clay) | 1.70 | lbs. | $ | 1.80 | per lb. | $ | 3.06 | |
| Direct labor | 1.70 | hrs. | $ | 11.00 | per hr. | 18.70 | ||
| Variable manufacturing overhead (based on direct labor hours) | 1.70 | hrs. | $ | 1.10 | per hr. | 1.87 | ||
| Fixed manufacturing overhead ($420,500.00 ÷ 145,000.00 units) | 2.90 | |||||||
Barley Hopp had the following actual results last year:
| Number of units produced and sold | 150,000 | |
| Number of pounds of clay used | 268,200 | |
| Cost of clay | $ | 455,940 |
| Number of labor hours worked | 195,000 | |
| Direct labor cost | $ | 2,827,500 |
| Variable overhead cost | $ | 290,000 |
| Fixed overhead cost | $ | 440,000 |
Required:
1. Calculate the direct materials price, quantity, and
total spending variances for Barley Hopp. (Do not round
your intermediate calculations. Indicate the effect of each
variance by selecting "F" for favorable and "U" for
unfavorable.)
2. Calculate the direct labor rate, efficiency,
and total spending variances for Barley Hopp.
(Do not round your intermediate calculations. Indicate the
effect of each variance by selecting "F" for favorable and "U" for
unfavorable.)
3. Calculate the variable overhead rate,
efficiency, and total spending variances for Barley
Hopp. (Do not round your intermediate
calculations. Indicate the effect of each variance by selecting "F"
for favorable/Overapplied and "U" for
unfavorable/underapplied.)
In: Accounting
Question I Value Derivatives
An investor is very bullish on LewCo, a nondividend paying company. The current spot price of the company’s equity is $50 per share. The investor is confident the company will solve the social distancing issue and that the value of the stock will be at least $100 in 12 months.
The investor uses a 12-period binomial tree assuming
S0 = $50
T = 12 months
r = 30 basis points per month
u=1.1 per month
d = 1/u= 1.1-1 per month 1.
1. Apply the binomial tree model to value a 12-month European style call with a strike of $100. What is the call premium?
2. Use put-call parity to value the put on the same asset, for the same expiration, and with the same strike. What is the put premium?
3. The investor is considering two other calls. One with a strike of $200. Another with a strike of $0. The values of these structures should be evident to you. What is the premium on the call with a strike of $200? Why? What is the premium on the call with the strike of $0? Why?
4. Why do investors use options? To answer this, we consider an investor with $5,000 to invest. Assume the spot price in 12 months is $100, as predicted by the investor. Calculate the amount the investor will make spending the $5,000 to buy shares of stock, spending the $5,000 to buy puts with a strike of $100, or spending the $5,000 to buy calls with a strike of $100? Based on this analysis, what is the advantage of using options?
5. What would be the premium of a derivative structure paying the square of the call payoff in each node of the terminal distribution?
In: Finance
(3) Malls face increasing completion from Amazon. Last year the average consumer spent $50 at the local mall. Is consumer spending decreasing? This year, in a random sample of shoppers, each was asked how much money she/he spent on the last trip to the local mall. Do they data support at a=10% significance level the research hypothesis that average shopper this year spent less that $50?
a. What are the null and alternative hypotheses?
b. What is the appropriate p-value?
c. Can they infer at the 10% significance level that consumer spending decreased since last year? State your conclusion.
| Consumer Spending |
| $ 54.88 |
| $ 32.81 |
| $ 42.84 |
| $ 34.75 |
| $ 64.45 |
| $ 43.76 |
| $ 46.56 |
| $ 39.45 |
| $ 54.25 |
| $ 50.78 |
| $ 33.86 |
| $ 44.31 |
| $ 56.61 |
| $ 35.02 |
| $ 29.42 |
| $ 53.53 |
| $ 82.91 |
| $ 33.40 |
| $ 54.90 |
| $ 43.07 |
| $ 57.16 |
| $ 55.89 |
| $ 37.21 |
| $ 40.60 |
| $ 47.09 |
| $ 57.19 |
| $ 30.19 |
| $ 64.56 |
| $ 54.18 |
| $ 61.05 |
| $ 44.26 |
| $ 55.59 |
| $ 69.89 |
| $ 50.18 |
| $ 52.08 |
| $ 44.97 |
| $ 60.56 |
| $ 41.90 |
| $ 61.05 |
| $ 55.94 |
| $ 51.43 |
| $ 43.11 |
| $ 61.13 |
| $ 37.41 |
| $ 48.33 |
| $ 41.46 |
| $ 37.78 |
| $ 54.32 |
| $ 45.62 |
| $ 61.68 |
| $ 52.47 |
| $ 42.88 |
| $ 43.15 |
| $ 55.39 |
| $ 43.01 |
| $ 47.93 |
| $ 48.12 |
| $ 47.68 |
| $ 61.72 |
| $ 49.53 |
| $ 61.75 |
| $ 45.04 |
| $ 41.59 |
| $ 57.66 |
| $ 31.66 |
| $ 47.72 |
| $ 33.90 |
| $ 50.32 |
| $ 43.22 |
| $ 48.07 |
| $ 48.42 |
| $ 52.58 |
| $ 59.25 |
| $ 36.57 |
| $ 70.23 |
| $ 48.08 |
| $ 60.11 |
| $ 58.14 |
| $ 60.73 |
| $ 65.73 |
| $ 53.19 |
| $ 48.95 |
| $ 61.29 |
| $ 19.56 |
| $ 59.92 |
| $ 41.50 |
| $ 48.36 |
| $ 44.44 |
| $ 46.34 |
| $ 49.35 |
| $ 43.52 |
| $ 51.96 |
| $ 54.89 |
| $ 30.68 |
| $ 54.74 |
| $ 36.38 |
| $ 45.55 |
| $ 38.03 |
| $ 46.97 |
| $ 39.56 |
| $ 42.98 |
| $ 56.00 |
| $ 46.23 |
| $ 50.77 |
| $ 46.89 |
| $ 43.97 |
| $ 28.55 |
| $ 32.10 |
| $ 38.54 |
| $ 41.21 |
| $ 52.71 |
| $ 28.89 |
| $ 24.70 |
| $ 53.83 |
| $ 54.92 |
In: Statistics and Probability
PA9-1 Calculating Direct Material, Direct Labor, Variable Overhead Variances [LO 9-3, 9-4, 9-5]
Barley Hopp, Inc., manufactures custom-ordered commemorative
beer steins. Its standard cost information follows:
| Standard Quantity | Standard Price (Rate) | Standard Unit Cost | ||||||
| Direct materials (clay) | 1.60 | lbs. | $ | 1.70 | per lb. | $ | 2.72 | |
| Direct labor | 1.60 | hrs. | $ | 16.00 | per hr. | 25.60 | ||
| Variable manufacturing overhead (based on direct labor hours) | 1.60 | hrs. | $ | 1.30 | per hr. | 2.08 | ||
| Fixed manufacturing overhead ($374,000.00 ÷ 170,000.00 units) | 2.20 | |||||||
Barley Hopp had the following actual results last year:
| Number of units produced and sold | 175,000 | |
| Number of pounds of clay used | 318,200 | |
| Cost of clay | $ | 572,760 |
| Number of labor hours worked | 220,000 | |
| Direct labor cost | $ | 4,510,000 |
| Variable overhead cost | $ | 340,000 |
| Fixed overhead cost | $ | 380,000 |
Required:
1. Calculate the direct materials price, quantity, and
total spending variances for Barley Hopp. (Do not round
your intermediate calculations. Indicate the effect of each
variance by selecting "F" for favorable and "U" for
unfavorable.)
2. Calculate the direct labor rate, efficiency,
and total spending variances for Barley Hopp.
(Do not round your intermediate calculations. Indicate the
effect of each variance by selecting "F" for favorable and "U" for
unfavorable.)
3. Calculate the variable overhead rate,
efficiency, and total spending variances for Barley
Hopp. (Do not round your intermediate
calculations. Indicate the effect of each variance by selecting "F"
for favorable/Overapplied and "U" for
unfavorable/underapplied.)
In: Accounting
Walkenhorst Company’s machining department prepared its 2016 budget based on the following data:
|
Practical capacity |
40,000 |
Units |
|
Machine hours per unit |
2.00 |
|
|
Variable factory overhead |
$3.00 |
Per machine hour |
|
Fixed factory overhead |
$392,000 |
|
The department uses machine hours to apply factory overhead. In 2016, the department used 85,400 machine hours and $653,000 in total manufacturing overhead to manufacture 42,030 units. Actual fixed overhead for the year was $399,000. |
|
Required: |
|
|
Determine for the year: |
|
|
1. |
The variable, fixed, and total factory overhead application rates. (Round your answers to 2 decimal places.) |
|
Variable overhead application rate |
|
|
Fixed overhead application rate |
|
|
Total Factory overhead application rate |
|
2. |
The flexible budget for overhead cost based on output achieved in 2016. (Do not round intermediate calculations. Round your final answers to nearest whole dollar amount.) |
|
Flexible budget for overhead cost |
|
3. |
The fixed overhead production volume variance. (Do not round intermediate calculations. Round your final answers to nearest whole dollar amount.) |
|
Fixed overhead production volume variance |
Favorable |
|
4. |
The total overhead spending variance. (Do not round intermediate calculations. Round your final answers to nearest whole dollar amount.) |
|
Spending variance |
Unfavorable |
|
5. |
The overhead efficiency variance. (Do not round intermediate calculations. Round your final answers to nearest whole dollar amount.) |
|
Efficiency variance |
Unfavorable |
|
6. |
The variable and fixed overhead spending variances. (Do not round intermediate calculations. Round your final answers to nearest whole dollar amount.) |
|
Variable overhead |
Favorable |
|
|
Fixed overhead |
Favorable |
In: Accounting
PA9-5 Calculating Direct Materials, Direct Labor, Variable Manufacturing Overhead Variances [LO 9-3, 9-4, 9-5]
Bullseye Company
manufactures dartboards. Its standard cost information
follows:
| Standard Quantity | Standard Price (Rate) | Standard Unit Cost | ||||||
| Direct materials (cork board) | 2.5 | sq. ft. | $ | 2.00 | per sq. ft. | $ | 5.00 | |
| Direct labor | 1 | hrs. | $ | 14.00 | per hr. | 14.00 | ||
| Variable manufacturing overhead (based on direct labor hours) | 1 | hrs. | $ | 0.50 | per hr. | 0.50 | ||
| Fixed manufacturing overhead ($40,000 ÷ 160,000 units) | 0.25 | |||||||
Bullseye has the following actual results for the month of
September:
| Number of units produced and sold | 140,000 | |
| Number of square feet of corkboard used | 360,000 | |
| Cost of corkboard used | $ | 756,000 |
| Number of labor hours worked | 148,000 | |
| Direct labor cost | $ | 1,938,800 |
| Variable overhead cost | $ | 72,000 |
| Fixed overhead cost | $ | 50,000 |
Required:
1. Calculate the direct materials price, quantity,
and total spending variances for Bullseye. (Do not round
your intermediate calculations. Indicate the effect of each
variance by selecting "F" for favorable, "U" for
unfavorable.)
2. Calculate the direct labor rate, efficiency,
and total spending variances for Bullseye. (Do not round
your intermediate calculations. Indicate the effect of each
variance by selecting "F" for favorable, "U" for
unfavorable.)
3. Calculate the variable overhead rate,
efficiency, and total spending variances for Bullseye. (Do
not round your intermediate calculations. Indicate the effect of
each variance by selecting "F" for favorable/Overapplied and "U"
for unfavorable/underapplied.)
In: Accounting
The following table includes quarterly working capital levels for your firm for the next year.
|
Quarters |
|||||
|
?($000)???????? |
1 |
2 |
3 |
4 |
|
|
Cash |
104 |
104 |
104 |
104 |
|
|
Accounts Receivable |
198 |
97 |
106 |
610 |
|
|
Inventory |
205 |
504 |
908 |
53 |
|
|
Accounts Payable |
110 |
103 |
99 |
105 |
|
If you choose to enter the year with $397,000 total in cash and maintain a minimum cash balance of $104,000?, what is your maximum?short-term borrowing?
This is the answer but I need someone to show me how to calculate this in excel. I need details for how the "cash at the beginning of the qrt" was calculated.
You must find the total working capital for each quarter and then subtract the permanent working? capital, which is the smallest working capital of the four quarters. This will give you the temporary working capital for each quarter.
The temporary working capital for each quarter are shown? below:
|
($000) |
Q1 |
Q2 |
Q3 |
Q4 |
||||
|
Cash |
$ |
104 |
$ |
104 |
$ |
104 |
$ |
104 |
|
Accounts receivable |
198 |
97 |
106 |
610 |
||||
|
Inventory |
205 |
504 |
908 |
53 |
||||
|
Accounts payable |
110 |
103 |
99 |
105 |
||||
|
NWC |
$ |
397 |
$ |
602 |
$ |
1,019 |
$ |
662 |
|
- Permanent WC needs |
(397) |
(397) |
(397) |
(397) |
||||
|
Temporary WC needs |
$ |
0 |
$ |
205 |
$ |
622 |
$ |
265 |
?Below, we determine the maximum amount of? short-term borrowing needed if the firm enters the year with $397,000 in cash.
|
($000) |
Q1 |
Q2 |
Q3 |
Q4 |
||||
|
Cash at beginning of quarter |
$ |
397 |
$ |
397 |
$ |
192 |
$ |
104 |
|
Minimum cash balance |
104 |
104 |
104 |
104 |
||||
|
Temporary working capital needs |
0 |
205 |
622 |
265 |
||||
|
Change in NWC |
205 |
417 |
(357) |
|||||
|
Financing |
||||||||
|
Starting available excess cash |
$ |
293 |
$ |
293 |
$ |
88 |
$ |
0 |
|
- Increase (decrease) in NWC |
0 |
205 |
417 |
(357) |
||||
|
+ Increase (decrease) ST Debt |
0 |
0 |
329 |
(329) |
||||
|
= Ending excess cash |
$ |
293 |
$ |
88 |
$ |
0 |
$ |
28 |
|
Ending total cash balance |
397 |
192 |
104 |
132 |
||||
|
Total short term borrowing |
0 |
0 |
329 |
0 |
In: Finance
Samson plc is registered for VAT.
The following information relates to the company’s VAT return for the quarter ended 31 March 2020:
Unless stated otherwise, all of the figures above are exclusive of VAT.
YOU ARE REQUIRED TO:
State the consequences if Samson plc does not submit the return for the quarter ended 31 March 2020 until 25 May 2020.
(maximum word count 80 words)
TOTAL 20 MARKS
UK TAX
In: Accounting
Exercise 6-2 (Algo) Dropping or Retaining a Segment [LO6-2]
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a racing bike. Data on sales and expenses for the past quarter follow:
| Total | Dirt Bikes |
Mountain Bikes | Racing Bikes |
|||||||||
| Sales | $ | 926,000 | $ | 265,000 | $ | 405,000 | $ | 256,000 | ||||
| Variable manufacturing and selling expenses | 465,000 | 113,000 | 201,000 | 151,000 | ||||||||
| Contribution margin | 461,000 | 152,000 | 204,000 | 105,000 | ||||||||
| Fixed expenses: | ||||||||||||
| Advertising, traceable | 70,200 | 8,600 | 40,800 | 20,800 | ||||||||
| Depreciation of special equipment | 43,700 | 20,700 | 7,100 | 15,900 | ||||||||
| Salaries of product-line managers | 114,000 | 40,600 | 38,100 | 35,300 | ||||||||
| Allocated common fixed expenses* | 185,200 | 53,000 | 81,000 | 51,200 | ||||||||
| Total fixed expenses | 413,100 | 122,900 | 167,000 | 123,200 | ||||||||
| Net operating income (loss) | $ | 47,900 | $ | 29,100 | $ | 37,000 | $ | (18,200) | ||||
*Allocated on the basis of sales dollars.
Management is concerned about the continued losses shown by the racing bikes and wants a recommendation as to whether or not the line should be discontinued. The special equipment used to produce racing bikes has no resale value and does not wear out.
Required:
1. What is the financial advantage (disadvantage) per quarter of discontinuing the Racing Bikes?
2. Should the production and sale of racing bikes be discontinued?
3. Prepare a properly formatted segmented income statement that would be more useful to management in assessing the long-run profitability of the various product lines.
What is the financial advantage (disadvantage) per quarter of discontinuing the Racing Bikes?
|
?
Prepare a properly formatted segmented income statement that would be more useful to management in assessing the long-run profitability of the various product lines.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Assume the required reserve ratio at The First Bank of Idaho is 10%. The First Idaho Bank is a primary dealer, which means that it is a financial institution that is able to buy and sell securities directly to the U.S. Federal Reserve (Fed). Remember any bank in the U.S. can borrow from the Fed.
Provided below is the balance sheet for The First Bank of Idaho:
|
Type of Asset |
Asset Amount |
Type of Liability |
Bank Capital |
|
Reserves |
$50,000 |
Checkable Deposits |
$200,000 |
|
Loans |
$120,000 |
Savings Deposits |
$100,000 |
|
Securities |
$150,000 |
||
|
Bank Capital |
$20,000 |
||
Use the information as well as the balance sheet for The First Bank of Idaho provided above to complete and answer the following:
What is the amount of excess reserves held by The First Bank of Idaho?
The Fed buys $50,000 of securities from The First Bank of Idaho and pays for those securities by increasing The First Bank of Idaho’s bank deposits at the Fed. Show the effect of this transaction on The First Bank of Idaho’s balance sheet.
When completing this part of your answer, remember that reserves equal bank deposits held at the Fed, plus vault cash.
What happens to excess reserves when the Fed buys securities from The First Bank of Idaho?
What happens to the amount of loans The First Bank of Idaho can create after the Fed buys securities? What will happen to the money supply if The First Bank of Idaho makes additional loans?
Go back to the original balance sheet. Suppose The First Bank of Idaho borrows $25,000 from the Fed. Show the effect of that transaction on The First Bank of Idaho’s balance sheet.
What happens to excess reserves at The First Bank of Idaho after the discount loan? What will happen to the money supply?
What happens to the amount of loans The First Bank of Idaho can create after the discount loan?
Go back to the original balance sheet. The Fed has a new tool that can pay interest on reserves held at the Fed. If the interest rate on reserves increases, will The First Bank of Idaho be more- or less-likely to hold excess reserves? What will happen to the amount of loans The First Bank of Idaho will make if the interest rate on reserves increases? What will happen to the money supply?
The Fed is currently using three tools: open market operations, interest rate on reserves, and forward guidance. Define each tool and explain how the Fed uses that tool to increase and decrease the money supply.
In: Economics