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.
| Month | ||||||||
| 1 | 2 | 3 | 4 | |||||
| Throughput time (days) | ? | ? | ? | ? | ||||
| Delivery cycle time (days) | ? | ? | ? | ? | ||||
| Manufacturing cycle efficiency (MCE) | ? | ? | ? | ? | ||||
| Percentage of on-time deliveries | 82 | % | 77 | % | 74 | % | 71 | % |
| Total sales (units) | 2100 | 2010 | 1907 | 1835 | ||||
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:
| Average per Month (in days) | |||||||||
| 1 | 2 | 3 | 4 | ||||||
| Move time per unit | 0.6 | 0.3 | 0.4 | 0.4 | |||||
| Process time per unit | 2.3 | 2.2 | 2.1 | 2.0 | |||||
| Wait time per order before start of production | 20.0 | 21.9 | 26.0 | 28.0 | |||||
| Queue time per unit | 4.7 | 5.5 | 6.4 | 7.4 | |||||
| Inspection time per unit | 0.8 | 1.1 | 1.1 | 0.8 | |||||
Required:
1- Compute the throughput time for each month. Compute the delivery cycle time for each month. Compute the manufacturing cycle efficiency (MCE) for each month.
2. Evaluate the company’s performance over the last four months.
3-a. Refer to the move time, process time, and so forth, given for month 4. Assume that in month 5 the move time, process time, and so forth, are the same as in month 4, except that through the use of Lean Production the company is able to completely eliminate the queue time during production. Compute the new throughput time and MCE.
3-b. Refer to the move time, process time, and so forth, given for month 4. Assume in month 6 that the move time, process time, and so forth, are again the same as in month 4, except that the company is able to completely eliminate both the queue time during production and the inspection time. Compute the new throughput time and MCE.
In: Accounting
The units of an item available for sale during the year were as follows: Jan. 1 Inventory 20 units at $41 Feb. 17 Purchase 12 units at $42 Jul. 21 Purchase 11 units at $45 Nov. 23 Purchase 8 units at $47 There are 10 units of the item in the physical inventory at December 31. The periodic inventory system is used. Round average unit cost to one decimal and final answers to the nearest whole dollar, if required. a. Determine the inventory cost by the first-in, first-out method. $ b. Determine the inventory cost by the last-in, first-out method. $ c. Determine the inventory cost by the weighted average cost method. $
In: Accounting
Last year Minden Company introduced a new product and sold 25,200 units of it at a price of $92 per unit. The product's variable expenses are $62 per unit and its fixed expenses are $838,500 per year.
Required:
1. What was this product's net operating income (loss) last year?
2. What is the product's break-even point in unit sales and dollar sales?
3. Assume the company has conducted a marketing study that estimates it can increase annual sales of this product by 5,000 units for each $2 reduction in its selling price. If the company will only consider price reductions in increments of $2 (e.g., $68, $66, etc.), what is the maximum annual profit that it can earn on this product? What sales volume and selling price per unit generate the maximum profit?
Assume the company has conducted a marketing study that estimates it can increase annual sales of this product by 5,000 units for each $2 reduction in its selling price. If the company will only consider price reductions in increments of $2 (e.g., $68, $66, etc.), what is the maximum annual profit that it can earn on this product? What sales volume and selling price per unit generate the maximum profit?
Show less
|
4. What would be the break-even point in unit sales and in dollar sales using the selling price that you determined in requirement 3?
|
In: Accounting
Jesper Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Jesper Manufacturing's operations:
|
Current Assets as of December 31 (prior year): |
|
|
Cash |
$4,460 |
|
Accounts receivable, net |
$52,000 |
|
Inventory |
$15,400 |
|
Property, plant, and equipment, net |
$122,000 |
|
Accounts payable |
$44,000 |
|
Common stock |
$126,860 |
|
Retained earnings |
$23,000 |
|
January |
$80,100 |
|
February |
$89,100 |
|
March |
$82,800 |
|
April |
$85,500 |
|
May |
$77,400 |
Requirements:
In: Accounting
The nominal price (per pound) of apples for each year is shown in the timeline below.
What is the real price of apples in year 2002 (as seen from year 2001).
Calculate your answer to the nearest penny (e.g., 3.81)
| Year | 2001 | 2002 | 2003 | 2004 |
| Nominal Price | $2.5 | $2.54 | $2.7 | $2.8 |
| Price Level | 151 | 155 | 157 | 158 |
| Price Adjustment | ||||
| Real Price |
In: Finance
QUESTION 11
Marc and Michelle are married and earned salaries this year of $68,000 and $15,000, respectively. In addition to their salaries, they received interest of $350 from municipal bonds and $500 from corporate bonds. Marc contributed $3,000 to a qualified Individual Retirement Account, and Marc paid alimony to a prior spouse in the amount of $1,500 (2017 divorce). Marc and Michelle have a 10-year-old son, Matthew, who lived with them throughout the entire year. Thus, Marc and Michelle are allowed to claim a $2,000 child tax credit for Matthew. Marc and Michelle paid $6,000 of expenditures that qualify as itemized deductions and they had a total of $3,500 in federal income taxes withheld from their paychecks during the course of the year. What is Marc and Michelle’s gross income?
QUESTION 12
Same facts as Question 11 – What is Marc and Michelle’s adjusted gross income?
QUESTION 13
Same facts as Question 11 – What is Marc and Michelle’s taxable income?
QUESTION 14
Same facts as Question 11 – What is Marc and Michelle’s taxes payable or refund due?
In: Accounting
Company A and B can borrow for a 3-year term at the following rates. While A desires fixed rate borrowing, B prefers floating rate borrowing.
Fixed Rate Floating Rate
A 8.5% LIBOR + 0.5%
B 7% LIBOR
The swap bank currently makes a market for plain vanilla 3-year interest rate swaps at 7.25% - 7.5%.
Please Complete ALL Parts!!!!
In: Finance
Danni is a single 30 percent owner of Kolt (a business entity). In the current year, Kolt reported a $1,000,000 business loss. Answer the following questions associated with each of the following alternative scenarios: (Leave no answer blank. Enter zero if applicable.) Problem 15-55 Part a a. Kolt is organized as a C corporation and Danni works 20 hours a week as an employee for Kolt. Danni has a $200,000 basis in her Kolt stock. How much of Kolt’s loss is Danni allowed to deduct this year against her other income?
In: Accounting
Danni is a single 30 percent owner of Kolt (a business entity). In the current year, Kolt reported a $1,000,000 business loss. Answer the following questions associated with each of the following alternative scenarios: (Leave no answer blank. Enter zero if applicable.) Problem 15-55 Part b b. Kolt is organized as an LLC taxed as a partnership. Thirty percent of Kolt’s loss is allocated to Danni. Danni works 20 hours a week on Kolt business activities (she is not considered to be a passive investor in Kolt). Danni has a $400,000 basis in her Kolt ownership interest and she also has a $400,000 at-risk amount in her investment in Kolt. Danni does not report income or loss from any other business activity investments. How much of the $300,000 loss allocated to her from Kolt is Danni allowed to deduct this year?
In: Accounting
Question 1.
The following data is from the accounting records of Padcore Ltd. for the year just ended:
|
Administrative expenses |
64,000 |
|
Administrative salaries |
110,000 |
|
Depreciation, factory |
25,000 |
|
Depreciation, office equipment |
8,000 |
|
Direct labour |
400,000 |
|
Factory equipment maintenance |
15,000 |
|
Factory supervisor's salary |
80,000 |
|
Insurance, factory |
22,000 |
|
Raw materials purchased |
260,000 |
|
Sales |
1,700,000 |
|
Sales salaries and commissions |
120,000 |
|
Selling expenses |
40,000 |
|
Supplies, factory |
9,000 |
|
Utilities, factory |
12,000 |
|
Beginning of |
End of |
|||
|
the Year |
the Year |
|||
|
Raw Materials |
20,000 |
35,000 |
||
|
Work in process |
40,000 |
30,000 |
||
|
Finished goods |
65,000 |
40,000 |
Calculate the cost of goods manufactured, cost of goods sold and net income for the year just ended:
Question 2.
Waldorf Corporation had the following overhead costs for the previous year (Waldorf allocates overhead on the basis of direct labour hours):
|
Labour hours |
Total Overhead |
|||
|
1st Quarter |
7,000 |
$ 75,000 |
||
|
2nd Quarter |
6,000 |
$ 74,000 |
||
|
3rd Quarter |
8,000 |
$ 77,000 |
||
|
4th Quarter |
7,500 |
$ 76,000 |
Assume that total overhead is comprised of Indirect materials (a variable cost), Rent (a fixed cost) and Maintenance (a mixed cost). The breakdown of these three costs at the 6,000 labour hour level is as follows:
|
Indirect materials (V) |
$ 3,600 |
|
|
Rent (F) |
35,000 |
|
|
Maintenance (M) |
35,400 |
|
|
$ 74,000 |
Determine how much of the total overhead at the 8,000 direct labour hour is maintenance. Using the amount just determined and the high low method, estimate a cost formula for maintenance. Determine what the cost formula for total overhead would be and estimate what total overhead costs would be at the 10,000 direct labour hour level.
Question 2A
Question 3.
The income statement for Big Franks Bicycle Emporium for the month just ended is as follows:
|
Sales |
300,000 |
|||
|
Cost of goods sold |
140,000 |
|||
|
Gross margin |
160,000 |
|||
|
Less operating expenses |
||||
|
Selling expenses |
40,000 |
|||
|
Depreciation |
25,000 |
|||
|
Admin expenses |
65,000 |
|||
|
Total operating expenses |
130,000 |
|||
|
Net income |
30,000 |
|||
Additional information:
· On average Frank sells his bikes for $300 each
· The sales department has variable expenses of $12 per bike sold
· Depreciation expense is unaffected by changes in the sales level
· Admin costs are 70% fixed and 30% variable
Prepare an income statement for the month just ended using the contribution margin approach.
Question 4.
Wyatt Enterprises manufactures and sells a single product. The company’s sales and expenses for the month just ended are as follows:
|
Total |
Per Unit |
||
|
Sales |
$ 190,000 |
$ 50 |
|
|
Less variable expenses |
114,000 |
30 |
|
|
Contribution margin |
76,000 |
$ 20 |
|
|
less fixed expenses |
60,000 |
||
|
Net income |
$ 16,000 |
Determine the break-even point in terms of both units and dollars. How many units would need to be sold in a month to achieve a target profit of $25,000? What is Wyatt’s margin of safety in both dollars and as a percentage?
Question 5.
The Happy Cardiologist Ltd. manufactures and sells pacemakers for $3,400 each. Cost information for March was as follows:
|
Variable manufacturing costs per unit |
$ 1,650 |
|
Variable selling costs per unit |
150 |
|
Fixed manufacturing costs |
290,000 |
|
Fixed admin costs |
825,000 |
In March, the company sold 750 pacemakers.
Calculate the margin of safety in both dollars and as a percentage. Compute the company’s degree of operating leverage. If sales increase by 20%, by how much will net income increase?
In: Accounting