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 | $ | 925,000 | $ | 262,000 | $ | 405,000 | $ | 258,000 |
Variable manufacturing and selling expenses | 463,000 | 113,000 | 196,000 | 154,000 | ||||
Contribution margin | 462,000 | 149,000 | 209,000 | 104,000 | ||||
Fixed expenses: | ||||||||
Advertising, traceable | 70,500 | 9,000 | 40,800 | 20,700 | ||||
Depreciation of special equipment | 44,200 | 20,900 | 7,800 | 15,500 | ||||
Salaries of product-line managers | 114,200 | 40,300 | 38,400 | 35,500 | ||||
Allocated common fixed expenses* | 185,000 | 52,400 | 81,000 | 51,600 | ||||
Total fixed expenses | 413,900 | 122,600 | 168,000 | 123,300 | ||||
Net operating income (loss) | $ | 48,100 | $ | 26,400 | $ | 41,000 | $ | (19,300) |
*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: |
1a. |
What is the impact on net operating income by discontinuing racing bikes? (Decreases should be indicated by a minus sign.) |
1b. | Should production and sale of the racing bikes be discontinued? | ||||
|
2a. | Prepare a segmented income statement. |
2b. |
Would a segmented income statement format be more usable to management in assessing the long-run profitability of the various product lines. |
||||
|
In: Accounting
The debits to Work in Process—Roasting Department for St. Arbucks Coffee Company for July 2016, together with information concerning production, are as follows:
Work in process, July 1, 600 pounds, 40% completed | $1,944* | |||
*Direct materials (600 X $2.8) | $1,680 | |||
Conversion (600 X 40% X $1.1) | $264 | |||
$1,944 | ||||
Coffee beans added during July, 19,000 pounds | 52,250 | |||
Conversion costs during July | 22,512 | |||
Work in process, July 31, 1,000 pounds, 40% completed | ? | |||
Goods finished during July, 18,600 pounds | ? |
All direct materials are placed in process at the beginning of production.
a. Prepare a cost of production report, presenting the following computations:
If an amount is zero, enter in "0". For the cost per equivalent unit, round your answer to two decimal places.
St. Arbucks Coffee Company | |||
Cost of Production Report-Roasting Department | |||
For the Month Ended July 31, 2016 | |||
Unit Information | |||
Units charged to production: | |||
Inventory in process, July 1 | |||
Received from materials storeroom | |||
Total units accounted for by the Roasting Department | |||
Units to be assigned costs: | |||
Equivalent Units | |||
Whole Units | Direct Materials (1) | Conversion (1) | |
Inventory in process, July 1 | |||
Started and completed in July | |||
Transferred to finished goods in July | |||
Inventory in process, July 31 | |||
Total units to be assigned costs | |||
Cost Information | |||
Costs per equivalent unit: | |||
Direct Materials | Conversion | ||
Total costs for July in Roasting Department | $ | $ | |
Total equivalent units | |||
Cost per equivalent unit (2) | $ | $ | |
Costs assigned to production: | |||
Direct Materials | Conversion | Total | |
Inventory in process, July 1 | $ | ||
Costs incurred in July | |||
Total costs accounted for by the Roasting Department | $ | ||
Cost allocated to completed and partially completed units: | |||
Inventory in process, July 1 balance | $ | ||
To complete inventory in process, July 1 | $ | $ | |
Cost of completed July 1 work in process | $ | ||
Started and completed in July | |||
Transferred to finished goods in July (3) | $ | ||
Inventory in process, July 31 (4) | |||
Total costs assigned by the Roasting Department | $ | ||
b. Compute and evaluate the change in cost per equivalent unit for direct materials and conversion from the previous month (June). If required, round your answers to the nearest cent.
Increase or Decrease | Amount | |
Change in direct materials cost per equivalent unit | $ | |
Change in conversion cost per equivalent unit | $ |
Check My Work1 more Check My Work uses remaining.
The debits to Work in Process—Roasting Department for St. Arbucks Coffee Company for July 2016, together with information concerning production, are as follows:
Work in process, July 1, 600 pounds, 40% completed | $1,944* | |||
*Direct materials (600 X $2.8) | $1,680 | |||
Conversion (600 X 40% X $1.1) | $264 | |||
$1,944 | ||||
Coffee beans added during July, 19,000 pounds | 52,250 | |||
Conversion costs during July | 22,512 | |||
Work in process, July 31, 1,000 pounds, 40% completed | ? | |||
Goods finished during July, 18,600 pounds | ? |
All direct materials are placed in process at the beginning of production.
a. Prepare a cost of production report, presenting the following computations:
If an amount is zero, enter in "0". For the cost per equivalent unit, round your answer to two decimal places.
St. Arbucks Coffee Company | |||
Cost of Production Report-Roasting Department | |||
For the Month Ended July 31, 2016 | |||
Unit Information | |||
Units charged to production: | |||
Inventory in process, July 1 | |||
Received from materials storeroom | |||
Total units accounted for by the Roasting Department | |||
Units to be assigned costs: | |||
Equivalent Units | |||
Whole Units | Direct Materials (1) | Conversion (1) | |
Inventory in process, July 1 | |||
Started and completed in July | |||
Transferred to finished goods in July | |||
Inventory in process, July 31 | |||
Total units to be assigned costs | |||
Cost Information | |||
Costs per equivalent unit: | |||
Direct Materials | Conversion | ||
Total costs for July in Roasting Department | $ | $ | |
Total equivalent units | |||
Cost per equivalent unit (2) | $ | $ | |
Costs assigned to production: | |||
Direct Materials | Conversion | Total | |
Inventory in process, July 1 | $ | ||
Costs incurred in July | |||
Total costs accounted for by the Roasting Department | $ | ||
Cost allocated to completed and partially completed units: | |||
Inventory in process, July 1 balance | $ | ||
To complete inventory in process, July 1 | $ | $ | |
Cost of completed July 1 work in process | $ | ||
Started and completed in July | |||
Transferred to finished goods in July (3) | $ | ||
Inventory in process, July 31 (4) | |||
Total costs assigned by the Roasting Department | $ | ||
b. Compute and evaluate the change in cost per equivalent unit for direct materials and conversion from the previous month (June). If required, round your answers to the nearest cent.
Increase or Decrease | Amount | |
Change in direct materials cost per equivalent unit | $ | |
Change in conversion cost per equivalent unit | $ |
Check My Work1 more Check My Work uses remaining.
In: Accounting
Katie's Wedding Planning Service completed the following transactions: (10 MARKS)
a. Billed clients for service, $1,350.
b. Completed work for clients who paid $500 cash.
c. Received a bill for utilities to be paid later, $120. d. Collected cash on account from clients, $800.
e. Paid the amount due for utilities.
f. Withdrew $400 cash for personal use.
In: Accounting
1. Alicia has been working for JMM Corp. for 32 years. Alicia participates in JMM’s defined benefit plan. Under the plan, for every year of service for JMM she is to receive 2 percent of the average salary of her three highest years of compensation from JMM. She retired on January 1, 2018. Before retirement, her annual salary was $570,000, $600,000, and $630,000 for 2015, 2016, and 2017. What is the maximum benefit Alicia can receive in 2018?
2.Brooklyn has been contributing to a traditional IRA for seven years (all deductible contributions) and has a total of $30,000 in the account. In 2018, she is 39 years old and has decided that she wants to get a new car. She withdraws $20,000 from the IRA to help pay for the car. She is currently in the 24 percent marginal tax bracket. What amount of the withdrawal, after tax considerations, will Brooklyn have available to purchase the car?
In: Accounting
Activity-Based Budget
Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette, and the Ultima. Forecast sales for next year are 15,600 for the Sleepeze, 12,700 for the Plushette, and 5,100 for the Ultima. Gene Dixon, vice president of sales, has provided the following information:
Suppose that Gene is considering three sales scenarios as follows:
Pessimistic | Expected | Optimistic | ||||||
Price | Quantity | Price | Quantity | Price | Quantity | |||
Sleepeze | $173 | 12,700 | $188 | 15,600 | $188 | 17,960 | ||
Plushette | 302 | 10,130 | 349 | 12,700 | 363 | 14,440 | ||
Ultima | 890 | 2,170 | 980 | 5,100 | 1,200 | 5,100 |
Suppose Gene determines that next year's Sales Division activities include the following:
Research—researching current and future conditions in the industry
Shipping—arranging for shipping of mattresses and handling calls from purchasing agents at retail stores to trace shipments and correct errors
Jobbers—coordinating the efforts of the independent jobbers who sell the mattresses
Basic ads—placing print and television ads for the Sleepeze and Plushette lines
Ultima ads—choosing and working with the advertising agency on the Ultima account
Office management—operating the Sales Division office
The percentage of time spent by each employee of the Sales Division on each of the above activities is given in the following table:
Gene |
Research Assistant |
Administrative Assistant |
||||
Research | - | 75 | % | - | ||
Shipping | 30 | % | - | 15 | % | |
Jobbers | 10 | 10 | 25 | |||
Basic ads | - | 15 | 40 | |||
Ultima ads | 35 | - | 5 | |||
Office management | 25 | - | 15 |
Additional information is as follows:
Required:
1. Prepare an activity-based budget for next year by activity. Use the expected level of sales activity. If required, round answers to the nearest dollar.
Olympus, Inc. | |||
Activity-Based Budget | |||
For Next Year | |||
Research: | |||
Salaries | $ | ||
Internet connections | $ | ||
Shipping: | |||
Salaries | $ | ||
Telephone | |||
Ship Sleepeze | |||
Ship Plushette | |||
Ship Ultima | |||
Jobbers: | |||
Salaries | $ | ||
Telephone | |||
Commissions | |||
Basic ads: | |||
Salaries | $ | ||
Advertising | |||
Ultima ads: | |||
Salaries | $ | ||
Advertising | |||
Office management: | |||
Salaries | $ | ||
Depreciation | |||
Office Supplies | |||
Total | $ |
2. On the basis of the budget prepared in Requirement 1, advise Gene regarding actions that might be taken to reduce expenses.
In: Accounting
On April 1, 2017, Jiro Nozomi created a new travel agency, Adventure Travel. The following transactions occurred during the company’s first month.
April |
1 |
Nozomi invested $31,000 cash and computer equipment worth $40,000 in the company in exchange for common stock. |
||
2 |
The company rented furnished office space by paying $2,100 cash for the first month’s (April) rent. |
|||
3 |
The company purchased $1,200 of office supplies for cash. |
|||
10 |
The company paid $2,700 cash for the premium on a 12-month insurance policy. Coverage begins on April 11. |
|||
14 |
The company paid $1,400 cash for two weeks' salaries earned by employees. |
|||
24 |
The company collected $20,000 cash on commissions from airlines on tickets obtained for customers. |
|||
28 |
The company paid $1,400 cash for two weeks' salaries earned by employees. |
|||
29 |
The company paid $500 cash for minor repairs to the company's computer. |
|||
30 |
The company paid $750 cash for this month's telephone bill. |
|||
30 |
The company paid $2,300 cash in dividends. |
The company's chart of accounts follows:
101 |
|||||
Cash |
405 |
Commissions Earned |
|||
106 |
Accounts Receivable |
612 |
Depreciation Expense—Computer Equip. |
||
124 |
Office Supplies |
622 |
Salaries Expense |
||
128 |
Prepaid Insurance |
637 |
Insurance Expense |
||
167 |
Computer Equipment |
640 |
Rent Expense |
||
168 |
Accumulated Depreciation—Computer Equip. |
650 |
Office Supplies Expense |
||
209 |
Salaries Payable |
684 |
Repairs Expense |
||
307 |
Common Stock |
688 |
Telephone Expense |
||
318 |
Retained Earnings |
901 |
Income Summary |
||
319 |
Dividends |
||||
Use the following information:
Required:
1. & 2. Prepare journal
entries to record the transactions for April and post them to the
ledger accounts in Requirement 6b. The company records prepaid and
unearned items in balance sheet accounts.
3. Using account balances from Requirement 6b,
prepare an unadjusted trial balance as of April 30.
4. Journalize and post the adjusting entries for
the month and prepare the adjusted trial balance.
5a. Prepare the income statement for the month of
April 30, 2017.
5b. Prepare the statement of retained earnings for
the month of April 30, 2017.
5c. Prepare the balance sheet at April 30,
2017.
6a. Prepare journal entries to close the temporary
accounts and then post to Requirement 6b.
6b. Post the journal entries to the ledger.
7. Prepare a post-closing trial balance.
In: Accounting
1. Change all of the numbers in the data area of your worksheet so that it looks like this:
If your formulas are correct, you should get the correct answers to the following questions. (a) What is the net operating income (loss) in Year 1 under absorption costing?(b) What is the net operating income (loss) in Year 2 under absorption costing? (c) What is the net operating income (loss) in Year 1 under variable costing? (d) What is the net operating income (loss) in Year 2 under variable costing? (e) The net operating income (loss) under absorption costing is less than the net operating income (loss) under variable costing in Year 2 because (You may select more than one answer.)
3. Make a note of the absorption costing net operating income (loss) in Year 2. At the end of Year 1, the company’s board of directors set a target for Year 2 of the net operating income of $70,000 under absorption costing. If this target is met, a hefty bonus would be paid to the CEO of the company. Keeping everything else the same from part (2) above, change the units produced in Year 2 to 5,400 units. (a) Would this change result in a bonus being paid to the CEO? Yes or No?(b) What is the net operating income (loss) in Year 2 under absorption costing? (c) Would this doubling of production in Year 2 be in the best interests of the company if sales are expected to continue to be 2,900 units per year? yes or no? |
In: Accounting
The company Smart Inc. is a company that produces T-shirts in Toronto area. The results of the company which has been mediocre for the past couple of years have been presented in the annual financial statement.
Sales (1 million units x 16$) 16 000 000$
Fixed Costs (10 000 000)
Variable Costs (1 million units x 10$) (10 000 000)
Depreciation (3 000 000)
Annual Profit (loss) (7 000 000)
According to the experts, this loss has been caused by the poor performance of the equipment in the factory. They suggest to the board of directors to replace the old equipment by new ones. Considering following information, the board of directors asks you to evaluate this project for the company.
The corporate tax rate is at 40%. The new equipment and new heavy machinery are in the category with a depreciation of 20%, the major renovations are depreciated at 25%, the new building is depreciated at 10%, all items depreciations are calculated with decreasing (declining) method. The computers and furniture are depreciated by linear method at 20%. Investors require 12% return on this type of project. Given this information, answer the following questions:
Questions:
In: Accounting
El Gato Painting Company maintains a checking account at
American Bank. Bank statements are prepared at the end of each
month. The November 30, 2018, reconciliation of the bank balance is
as follows:
Balance per bank, November 30 | $ | 3,391 | ||||
Add: Deposits outstanding | 1,360 | |||||
Less: Checks outstanding | ||||||
#363 | $ | 139 | ||||
#365 | 217 | |||||
#380 | 72 | |||||
#381 | 102 | |||||
#382 | 250 | (780 | ) | |||
Adjusted balance per bank, November 30 | $ | 3,971 | ||||
The company’s general ledger checking account showed the following
for December:
Balance, December 1 | $ | 3,971 | ||
Receipts | 44,250 | |||
Disbursements | (43,453 | ) | ||
Balance, December 31 | $ | 4,768 | ||
The December bank statement contained the following
information:
Balance, December 1 | $ | 3,391 | |||
Deposits | 44,600 | ||||
Checks processed | (43,518 | ) | |||
Service charges | (38 | ) | |||
NSF checks | (600 | ) | |||
Balance, December 31 | $ | 3,835 | |||
The checks that were processed by the bank in December include all
of the outstanding checks at the end of November except for check
#365. In addition, there are some December checks that had not been
processed by the bank by the end of the month. Also, you discover
that check #411 for $540 was correctly recorded by the bank but was
incorrectly recorded on the books as a $450 disbursement for
advertising expense. Included in the bank’s deposits is a $2,900
deposit incorrectly credited to the company’s account. The deposit
should have been posted to the credit of the Los Gatos Company. The
NSF checks have not been redeposited and the company will seek
payment from the customers involved.
Required:
1. Prepare a bank reconciliation for the El Gato
checking account at December 31, 2018.
2. Prepare any necessary adjusting journal entries
indicated.
In: Accounting
2016 | 2017 | 2018 | |
Compensation Expenses (Base & Variable Pay): | 38.5 | 41.7 | 40.6 |
Pay-for-Performance Expenses: | 7.5 | 10.3 | 9.9 |
Benefits Expenses: | 18.3 | 19.9 | 19.3 |
Total Operating Expenses: | 65.6 | 72.7 | 74.0 |
Total Revenue: | 199.1 | 191.9 | 178.7 |
Total Compensation Expense Factor: | 0.87 | 0.85 | 0.81 |
Pay-for-Performance Expense Factor: | 0.11 | 0.14 | 0.13 |
Total Compensation Revenue Factor: | 0.29 | 0.32 | 0.34 |
Pay-for-Performance Revenue Factor: | 0.04 | 0.05 | 0.06 |
What trends did you notice? What implications do they have?
In: Accounting
The text states, "Over sufficiently long time periods, net income equals cash inflows minus cash outflows, other than cash flows with owners." Demonstrate the accuracy of this statement in the following scenario: Two friends contributed $50,000 each to form a new business. The owners used the amounts contributed to purchase a machine for $100,000 cash. They estimated that the useful life of the machine was five years and the salvage value was $20,000. They rented out the machine to a customer for an annual rental of $25,000 a year for five years. Annual cash operating costs for insurance, taxes, and other items totaled $6,000 annually. At the end of the fifth year, the owners sold the equipment for $22,000, instead of the $20,000 salvage value initially estimated. (Hint: Compute the total net income and the total cash flows other than cash flows with owners for the five-year period as a whole.)
CASH | EQUIPMENT | COMMON STOCK | NET INCOME | |
cash contributed by owners | ||||
purchase of machine for cash | ||||
recognition of rent revenue | ||||
recognition of operating expenses | ||||
recognition of depreciation | ||||
sale of machine |
totals $ $ $ $
In: Accounting
Income Statement |
Statement of Stockholders’ Equity |
||||
Revenues |
#33 |
Common stock |
Retained earnings |
||
Expenses: |
Beginning |
$300,000 |
$275,000 |
||
Salaries |
$325,000 |
Issuance |
#35 |
||
Administrative |
340,000 |
Net income |
125,000 |
||
Utilities |
10,000 |
Dividends |
#36 |
||
Total expenses |
675,000 |
Ending |
$500,000 |
$350,000 |
|
Net income |
#34 |
||||
Balance Sheet |
|||||
Assets |
Liabilities |
||||
Cash |
$45,000 |
Accounts payable |
$20,000 |
||
A/R |
55,000 |
Notes payable |
250,000 |
||
Supplies |
#37 |
Total liabilities |
$270,000 |
||
Prepaid rent |
3,000 |
Stockholders’ Equity |
|||
Equipment |
450,000 |
Common stock |
? |
||
Building |
566,800 |
Retained earnings |
? |
||
Total stockholders’ equity |
#39 |
||||
Total assets |
#38 |
Total L and SE |
#40 |
||
33. $____________Revenue: 37. $__________Supplies:
34. $____________Net Income: 38. $__________Total Assets:
35. $____________Issuance: 39. $__________Stockholders’ Equity:
36. $____________Dividends: 40. $__________Total L & SE:
In: Accounting
Michelle J. and Fred M. Smith are married taxpayers who file a joint return. Their Social Security numbers are 123-45-6789 and 111-11-1112, respectively. Michelle’s birthday is September 21, 1971, and Fred’s is June 27, 1970. They live at 473 Revere Avenue, Stony Brook, 01850. Michelle is the office manager for Stony Brook Dental Clinic, 433 Broad Street, Stony Brook, NY 01850 (employer identification number 98-7654321). Fred is the manager of a Super Burgers fast-food outlet owned and operated by Plymouth Corporation, 1247 Central Avenue, Hauppauge, NY 11788 (employer identification number 11-1111111).
The following information is shown on their Wage and Tax Statements (Form W–2) for 2018.
Line |
Description |
Michelle |
Fred |
1 |
Wages, tips, other compensation |
$58,000 |
$62,100 |
2 |
Federal income tax withheld |
4,500 |
5,300 |
3 |
Social Security wages |
58,000 |
62,100 |
4 |
Social Security tax withheld |
3,596 |
3,850 |
5 |
Medicare wages and tips |
58,000 |
62,100 |
6 |
Medicare tax withheld |
841 |
900 |
15 |
State |
New York |
New York |
16 |
State wages, tips, etc. |
58,000 |
62,100 |
17 |
State income tax withheld |
2,950 |
3,100 |
The Smiths provide over half of the support of their two children, Cynthia (born January 25, 1994, Social Security number 123-45-6788) and John (born February 7, 1998, Social Security number 123-45-6786). Both children are full-time students and live with the Smiths except when they are away at college. Cynthia earned $6,200 from a summer internship in 2018, and John earned $3,800 from a part-time job.
During 2018, the Smiths provided 60% of the total support of Fred’s widower father, Sam Smith (born March 6, 1942, Social Security number 123-45-6787). Sam lived alone and covered the rest of his support with his Social Security benefits. Sam died in November, and Fred, the beneficiary of a policy on Sam’s life, received life insurance proceeds of $1,600,000 on December 28.
The Smiths had the following expenses relating to their personal residence during 2018:
Property taxes |
$5,000 |
Qualified interest on home mortgage (acquisition indebtedness) |
8,700 |
Repairs to roof |
5,750 |
Utilities |
4,100 |
Fire and theft insurance |
1,900 |
The Smiths had the following medical expenses for 2018: |
|
Medical insurance premiums |
$4,500 |
Doctor bill for Sam incurred in 2017 and not paid until 2018 |
7,600 |
Operation for Sam |
8,500 |
Prescription medicines for Sam |
900 |
Hospital expenses for Sam |
3,500 |
Reimbursement from insurance company, received in 2018 |
3,600 |
The medical expenses for Sam represent most of the 60% that Fred contributed toward his father’s support. Other relevant information follows: |
• When they filed their 2017 state return in 2018, the Smiths paid additional state income tax of $900.
• During 2018, Michelle and Fred attended a dinner dance sponsored by the Stony Brook Police Disability Association (a qualified charitable organization). The Smiths paid $300 for the tickets. The cost of comparable entertainment would normally be $50.
• The Smiths contributed $5,000 to Stony Brook Presbyterian Church and gave used clothing (cost of $1,200 and fair market value of $350) to the Salvation Army. All donations are supported by receipts, and the clothing is in very good condition.
• Via a crowdfunding site (gofundme.com), Michelle and Fred made a gift to a needy family who lost their home in a fire ($400). In addition, they made several cash gifts to homeless individuals downtown (estimatedto be $65).
• In 2018, the Smiths received interest income of $2,750, which was reported on a Form 1099–INT from Second National Bank, 125 Oak Street, Stony Brook, NY 01850 (Employer Identification Number 98-7654322).
• The home mortgage interest was reported on Form 1098 by Stony Brook Commercial Bank, P.O. Box 1000, Stony Brook, NY 01850 (Employer Identification Number 98-7654323). The mortgage (outstanding balance of $425,000 as of January 1, 2018) was taken out by the Smiths on May 1, 2014.
• Michelle’s employer requires that all employeeswear uniforms to work. During 2018, Michelle spent $850 on new uniforms and $566 on laundry charges.
• Fred paid $400 for an annual subscription to the Journal of Franchise Managementand $741 for annual membership dues to his professional association.
• Neither Michelle’s nor Fred’s employer reimburses for employee expenses.
• The Smiths do not keep the receipts for the sales taxes they paid and had no major purchases subject to sales tax.
• All members of the Smith family had health insurance coverage for all of 2018.
• This year the Smiths gave each of their children $2,000, which was then deposited into their Roth IRAs.
• Michelle and Fred paid no estimated Federal income tax. Neither Michelle nor Fred wants to designate $3 to the Presidential Election Campaign Fund.
REQUIRED: Tax Computation
Prepare their Federal and NYS tax returns. Compute net tax payable or refund due for Michelle and Fred Smith for 2018. If they have overpaid, they want the amount to be refunded to them. If you use tax forms for your computations, you will need Forms 1040 and Schedules A and B.
You must prepare Form 1040, Schedules A & B and any other appropriate forms and schedules. You may use tax software such as ProConnect or TurboTax, or manually prepare their tax returns.
Prepare their Federal and NYS income tax returns. Assume they were NYS residents for the entire year
In: Accounting
In: Accounting
Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. As an aid in planning, the company has decided to start using a contribution format income statement. To have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas:
Cost | Cost Formula | |
Cost of good sold | $26 per unit sold | |
Advertising expense | $183,000 per quarter | |
Sales commissions | 7% of sales | |
Shipping expense | ? | |
Administrative salaries | $93,000 per quarter | |
Insurance expense | $10,300 per quarter | |
Depreciation expense | $63,000 per quarter | |
Management has concluded that shipping expense is a mixed cost, containing both variable and fixed cost elements. Units sold and the related shipping expense over the last eight quarters follow:
Quarter | Units Sold | Shipping Expense |
||
Year 1: | ||||
First | 29,000 | $ | 173,000 | |
Second | 31,000 | $ | 188,000 | |
Third | 36,000 | $ | 230,000 | |
Fourth | 32,000 | $ | 193,000 | |
Year 2: | ||||
First | 30,000 | $ | 183,000 | |
Second | 33,000 | $ | 198,000 | |
Third | 47,000 | $ | 245,000 | |
Fourth | 44,000 | $ | 221,000 | |
Milden Company’s president would like a cost formula derived for shipping expense so that a budgeted contribution format income statement can be prepared for the next quarter.
2. In the first quarter of Year 3, the company plans to sell 35,000 units at a selling price of $56 per unit. Prepare a contribution format income statement for the quarter. (Do not round your intermediate calculations.)
Milden Company | ||
Budgeted Contribution Format Income Statement | ||
For the First Quarter, Year 3 | ||
Sales | $1,960,000 | |
Variable expenses: | ||
Cost of goods sold | $910,000 | |
Sales commissions | ||
Shipping expense | ||
Total variable expenses | 910,000 | |
Contribution margin | 1,050,000 | |
Fixed expenses: | ||
Total fixed expenses | 0 | |
Net operating income | $1,050,000 |
In: Accounting