Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing financial difficulty for some time. The company’s contribution format income statement for the most recent month is given below: Sales (13,200 units × $30 per unit) $ 396,000 Variable expenses 237,600 Contribution margin 158,400 Fixed expenses 176,400 Net operating loss $ (18,000 ) Required: 1. Compute the company’s CM ratio and its break-even point in unit sales and dollar sales. 2. The president believes that a $6,100 increase in the monthly advertising budget, combined with an intensified effort by the sales staff, will result in an $82,000 increase in monthly sales. If the president is right, what will be the increase (decrease) in the company’s monthly net operating income? 3. Refer to the original data. The sales manager is convinced that a 10% reduction in the selling price, combined with an increase of $30,000 in the monthly advertising budget, will double unit sales. If the sales manager is right, what will be the revised net operating income (loss)? 4. Refer to the original data. The Marketing Department thinks that a fancy new package for the laptop computer battery would grow sales. The new package would increase packaging costs by 0.50 cents per unit. Assuming no other changes, how many units would have to be sold each month to attain a target profit of $4,000? 5. Refer to the original data. By automating, the company could reduce variable expenses by $3 per unit. However, fixed expenses would increase by $59,000 each month. a. Compute the new CM ratio and the new break-even point in unit sales and dollar sales. b. Assume that the company expects to sell 21,000 units next month. Prepare two contribution format income statements, one assuming that operations are not automated and one assuming that they are. (Show data on a per unit and percentage basis, as well as in total, for each alternative.) c. Would you recommend that the company automate its operations (Assuming that the company expects to sell 21,000)?
In: Accounting
In: Accounting
If you were an auditor, how would you review a company’s accounting related records to identify potential liabilities which were not reported on the company’s balance sheet?
In: Accounting
Cost Assignment and JIT
Bunker Company produces two types of glucose monitors (basic and advanced). Both pass through two producing departments: Fabrication and Assembly. Bunker also has an Inspection Department that is responsible for testing monitors to ensure that they perform within prespecified tolerance ranges (a sampling procedure is used). Budgeted data for the three departments are as follows:
| Inspection | Fabrication | Assembly | |
| Overhead | $640,000 | $960,000 | $272,000 |
| Number of tests | — | 40,000 | 120,000 |
| Direct labor hours | — | 96,000 | 48,000 |
In the Fabrication Department, the basic model requires 1 hour(s) of direct labor and the advanced model requires 2 hour(s). In the Assembly Department, the basic model requires 1.2 hour(s) of direct labor and the advanced model requires 2.25 hours. There are 60,000 basic units produced and 32,000 advanced units.
Immediately after preparing the budgeted data, a consultant suggests that two manufacturing cells be created: one for the manufacture of the basic model and the other for the manufacture of the advanced model. Raw materials would be delivered to each cell, and goods would be shipped immediately to customers upon completion. Workers within each cell would also be trained to perform monitor testing. The total direct overhead costs estimated for each cell would be $304,000 for the basic cell and $960,000 for the advanced cell.
Required:
1. Allocate the inspection costs to each department.
| Fabrication | $ |
| Assembly | $ |
Compute the overhead cost per unit for each monitor. Overhead rates use direct labor hours. Round your intermediate calculations and final answers to the nearest cent.
| Basic | $ per unit |
| Advanced | $ per unit |
2. Compute the overhead cost per unit if manufacturing cells are created. If required, round your intermediate calculations and final answers to the nearest cent.
| Basic | $ per unit |
| Advanced | $ per unit |
Which unit overhead cost do you think is more accurate—the one computed with a departmental structure, or the one computed using a cell structure?
In: Accounting
Warnerwoods Company uses a periodic inventory system. It entered into the following purchases and sales transactions for March. Date Activities Units Acquired at Cost Units Sold at Retail Mar. 1 Beginning inventory 140 units @ $75 per unit Mar. 5 Purchase 440 units @ $80 per unit Mar. 9 Sales 460 units @ $110 per unit Mar. 18 Purchase 200 units @ $85 per unit Mar. 25 Purchase 280 units @ $87 per unit Mar. 29 Sales 240 units @ $120 per unit Totals 1,060 units 700 units For specific identification, the March 9 sale consisted of 90 units from beginning inventory and 370 units from the March 5 purchase; the March 29 sale consisted of 80 units from the March 18 purchase and 160 units from the March 25 purchase. 3. Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification.
In: Accounting
What are some patterns that could be found using diagnostic analysis? Between which types of variables?
In: Accounting
A lease agreement that qualifies as a finance lease calls for annual lease payments of $20,000 over a eight-year lease term (also the asset’s useful life), with the first payment at January 1, 2016, the beginning of the lease. The interest rate is 4%. The lessor’s fiscal year is the calendar year. The lessor manufactured this asset at a cost of $128,000. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) Required: a. Determine the price at which the lessor is “selling” the asset (present value of the lease payments). b. Create a partial amortization schedule through the second payment on January 1, 2017. c. What would be the amounts related to the lease that the lessor would report in its income statement for the year ended December 31, 2017 (ignore taxes)?
In: Accounting
Subsequent Events Facts:
You are performing an annual audit of a company with a December 31, 20X1 year-end. Your firm is planning to complete the audit on March 1, 20X2 and release the report on March 31, 20X2. On March 15, 20X2, two material subsequent events occur:
• A fire caused extensive damage to the company’s manufacturing plant in New Jersey.
• A large customer went bankrupt. At December 31, 20X1, the Company had a receivable of $2,500,000 from this customer; at December 31, 20X1 the Company had established an allowance for doubtful accounts of $700,000 for this customer.
Required:
1. Explain whether each subsequent event is a Type 1 or Type 2 Subsequent Event.
2. What is the impact of each subsequent event on the company’s audited financial statements for the year ended December 31, 20X1? Be specific as to whether (a) there will be an adjustment which will cause the company’s balance sheet and / or income statement to change plus footnote disclosure, (b) there will only be footnote disclosure, or (c) there will be no impact to either the financial statements or the footnote disclosures.
3. How should your Audit Firm date its audit report?
In: Accounting
25
Chhom, Inc., manufactures and sells two products: Product F9 and Product U4. Data concerning the expected production of each product and the expected total direct labor-hours (DLHs) required to produce that output appear below:
| Expected Production | Direct Labor-Hours Per Unit | Total Direct Labor-Hours | |
| Product F9 | 400 | 2.0 | 800 |
| Product U4 | 200 | 1.0 | 200 |
| Total direct labor-hours | 1,000 | ||
The direct labor rate is $24.40 per DLH. The direct materials cost per unit is $258 for Product F9 and $215 for Product U4.
The company is considering adopting an activity-based costing system with the following activity cost pools, activity measures, and expected activity:
| Estimated | Expected Activity | |||||
| Activity Cost Pools | Activity Measures | Overhead Cost | Product F9 | Product U4 | Total | |
| Labor-related | DLHs | $ | 34,600 | 800 | 200 | 1,000 |
| Production orders | orders | 54,940 | 200 | 200 | 400 | |
| Order size | MHs | 111,950 | 3,400 | 2,900 | 6,300 | |
| $ | 201,490 | |||||
The overhead applied to each unit of Product U4 under activity-based costing is closest to: (Round your intermediate calculations to 2 decimal places.)
In: Accounting
I am supposed to provide verbiage (shown below) and a chart to support the verbiage. I need your help in making a chart that I can paste into my word document from the current ratios from PepsiCo and Coca-Cola provided below. I know very little about excel or charts and hope you can assist me in learning this process. It will definitely be worth a 5-star rating for you. Thank you for your time and support.
The current ratio is enumerated from the balance sheet and is a comparison of the current assets to current liabilities which is calculated by dividing the two numbers (Law, 2016). PepsiCo’s total current assets for 2017 were $31,027,000 and the total current liabilities for the same period was $20,502,000. When these two numbers are divided, the current ratio is 1.51: 1 (PepsiCo, 2019). Coca-Cola’s total current assets for the same time frame were $36,545,000 and their total current liabilities in 2017 equaled $27,194,000. The partition of the statistics is equivalent to the current ratio of 1.34: 1 (Coca-Cola, 2018).
In: Accounting
One Friday afternoon years ago I was sitting in my office as the CEO of a young software company, when my department heads of software development and finance came in separately to each request an additional $125,000 in funding. My software development director wanted new product testing equipment and my CFO wanted to upgrade our accounting and business systems software. Both were legitimate requests that would help move the business forward. I couldn’t help but laugh: In the span of 10 minutes I was being asked to approve two unplanned expenses of $125,000, and they were as different as apples and oranges. Framing the Problem This story captures the dilemma faced by CEOs every day and is unique to the job. How do you compare two expenses that have almost no relation to each other?
When you have to decide between two expenses, you choose the one that you think based upon your experience will generate the most.
True or False and why please:)
In: Accounting
On May 31, 2016, Sandals report purchased a truck at a cost of $160,000. before placing the truck into service, The company spend $2,500 painting it, $500 replacing tires, and $5,000 overhauling the engine. The truck should remain in service for 5 years and have a residual value of $7,500. The truck’s annual mileage is expected to be 15,000 in each of the first two years and 10,000 miles in the next three years. In deciding which depreciation method to use, the general manager request depreciation schedule for each of the depreciation methods (straight line, unit-of production, and double – declining-balance). work out each depreciation in the depreciation schedule. pass all transaction in the journal entry. journal entry must be included. show working out for each depreciation.
work out the unit of production depreciation in the depreciation schedule. should work out based off the following information listed below
Miles 60,000
Cost 165,000
Residual value 7,500
Depreciable amount $165,000 - $7,500 = $157,500
Depreciation per unit 157,500 / 60,000 = 2.63
In: Accounting
Analyzing Manufacturing Cost Accounts
Clapton Company manufactures custom guitars in a wide variety of styles. The following incomplete ledger accounts refer to transactions that are summarized for May:
| Materials | |||||
|---|---|---|---|---|---|
| May 1 | Balance | 105,600 | May 31 | Requisitions | (a) |
| 31 | Purchases | 500,000 | |||
| Work in Process | |||||
|---|---|---|---|---|---|
| May 1 | Balance | (b) | May 31 | Completed jobs | (f) |
| 31 | Materials | (c) | |||
| 31 | Direct labor | (d) | |||
| 31 | Factory overhead applied | (e) | |||
| Finished Goods | |||||
|---|---|---|---|---|---|
| May 1 | Balance | 0 | May 31 | Cost of goods sold | (g) |
| 31 | Completed jobs | (f) | |||
| Wages Payable | |||||
|---|---|---|---|---|---|
| May 31 | Wages incurred | 396,000 | |||
| Factory Overhead | |||||
|---|---|---|---|---|---|
| May 1 | Balance | 26,400 | May 31 | Factory overhead applied | (e) |
| 31 | Indirect labor | (h) | |||
| 31 | Indirect materials | 15,400 | |||
| 31 | Other overhead | 122,500 | |||
In addition, the following information is available:
| Job No. | Style | Quantity | Direct Materials | Direct Labor | ||||||||
| 101 | AF1 | 330 | $ 82,500 | $ 59,400 | ||||||||
| 102 | AF3 | 380 | 105,400 | 72,600 | ||||||||
| 103 | AF2 | 500 | 132,000 | 110,000 | ||||||||
| 104 | VY1 | 400 | 66,000 | 39,600 | ||||||||
| 105 | VY2 | 660 | 118,800 | 66,000 | ||||||||
| 106 | AF4 | 330 | 66,000 | 30,800 | ||||||||
| Total | 2,600 | $570,700 | $378,400 | |||||||||
| Job No. | Style | Work in Process, May 1 |
|||
| 101 | AF1 | $26,400 | |||
| 102 | AF3 | 46,000 | |||
| Total | $72,400 | ||||
| Job No. | Style | Completed in May |
Units Sold in May |
|
| 101 | AF1 | X | 264 | |
| 102 | AF3 | X | 360 | |
| 103 | AF2 | 0 | ||
| 104 | VY1 | X | 384 | |
| 105 | VY2 | X | 530 | |
| 106 | AF4 | 0 | ||
Required:
1. Determine the missing amounts associated with each letter by completing the table below. If required, round your unit cost to two decimal places. If an answer is zero, enter in "0". Enter amounts as positive numbers.
| Job No. | Style | Quan- tity |
May 1 Work in Process |
Direct Materials | Direct Labor | Factory Overhead | Total Cost | Unit Cost | Units Sold | Cost of Goods Sold | ||||||||||
| No. 101 | AF1 | 330 | $ | $82,500 | $59,400 | $ | $ | $ | $ | |||||||||||
| No. 102 | AF3 | 380 | 105,400 | 72,600 | ||||||||||||||||
| No. 103 | AF2 | 500 | 132,000 | 110,000 | ||||||||||||||||
| No. 104 | VY1 | 400 | 66,000 | 39,600 | ||||||||||||||||
| No. 105 | VY2 | 660 | 118,800 | 66,000 | ||||||||||||||||
| No. 106 | AF4 | 330 | 66,000 | 30,800 | ||||||||||||||||
| Total | 2,600 | $ | $570,700 | $378,400 | $ | $ | $ | |||||||||||||
a. Materials Requisitions $
b. Work in Process Beginning Balance $
c. Direct Materials $
d. Direct Labor $
e. Factory overhead applied $
f. Completed jobs $
g. Cost of goods sold $
h. Indirect labor $
2. Determine the May 31 balances for each of the inventory accounts and factory overhead. Enter all amounts as positive numbers.
| Materials | $ |
| Work in Process | $ |
| Finished Goods | $ |
| Factory Overhead | $ |
In: Accounting
Abiy's Apple Pies purchases pies from a supplier, which it then sells to customers. During the year, it had the following information related to its inventory:
| Beginning Inventory | 120 units, purchased for $3 each. |
| Sale | 90 units, sold for $10 each |
| Purchase | 20 units, purchased for $4 each. |
| Purchase | 15 units, purchased for $5 each. |
| Sale | 25 units, sold for $11 each. |
A. Using the information above, complete the following table related to Abiy's Apple Pies. Assume Abiy's uses the periodic inventory method. Round your final answer to the nearest whole number.
| FIFO | LIFO | Average Cost | |
| Cost of Goods Sold | |||
| Ending Inventory |
B. Using the same information for Abiy's Apple Pies, complete the following table. Assume Abiy uses the perpetual inventory method.
| FIFO | LIFO | |
| Cost of Goods Sold | ||
| Ending Inventory | ||
| Gross Profit |
In: Accounting
Going Concern
Facts:
• A Chicago area company (“Company”) has been manufacturing metal gas tanks for passenger automobiles since 1918. The Company has always been a privately held family run business.
• The Company has been profitable for much of its history; retained earnings at the end of 20X1 was $20 million.
• Recently mandated EPA mpg requirements have caused automobile manufacturers to move to utilizing plastic gas tanks – which are much lighter than metal. This change in materials helped automobile manufacturers reduce auto weights and meet the increased mpg requirements.
• The Company decided not to convert their operation to plastic gas tanks because their expertise was only in manufacturing metal products.
• A few years back, the owners were faced with two options: Liquidate and distribute available assets or move into a different line of business. The Company decided to do the latter. The Company felt it could use its expertise to manufacture metal frames for televisions (like for Toshiba, Panasonic, etc.)
• The Company built a new manufacturing plant in Georgia for manufacturing these metal TV frames; the plant was financed with low interest rate IRBs (Industrial Revenue Bonds).
• The IRBs were for $25 million with a 20-year term. The Company has no other debt.
• Unfortunately, in its first two years of operation of the new metal picture frame plant– 20X2 & 20X3 – the Company lost $11 million and $8 million, respectively. The metal TV frame business is extremely competitive; sales prices of metal TV frames are quite low. The Company was simply unable to produce large quantities of metal frames at a cost which would enable the Company to generate adequate gross profit.
• You are finishing your Audit of 20X3 & discussed the Going Concern issue with the Company’s management, including the family owners. The owners / managers feel they have no choice but to continue producing metal TV frames – due to the 20-year IRB term.
• Management prepares financial projections for the next year which shows the Company breaking even; the projections reflect a significant increase in the gross profit – it is unclear how management will improve their gross profit margin so significantly. Part 1 (Continued)
Required: State whether you believe there is or is not substantial doubt about the Company’s ability to continue as a Going Concern. Provide your supporting arguments, specifically addressing: • Conditions and Events • Management’s Plans
Stating that you believe there is substantial doubt means that your Audit Firm’s Independent Auditor’s Report for the year of 20X3 will include an emphasis of a matter paragraph with the supporting footnote. (There is no need to formally draft the paragraph & supporting footnote.)
Stating that you believe there is not substantial doubt means that your Audit Firm’s Independent Auditor’s Report for the year of 20X3 will not include an emphasis of a matter paragraph but the Audited Financial Statements will include a footnote describing the conditions and events and how management’s plans alleviated the conditions and events. (There is no need to formally draft the footnote.)
In: Accounting