Decision on Accepting Additional Business
Brightstone Tire and Rubber Company has capacity to produce 153,000 tires. Brightstone presently produces and sells 117,000 tires for the North American market at a price of $111 per tire. Brightstone is evaluating a special order from a European automobile company, Euro Motors. Euro is offering to buy 18,000 tires for $93.95 per tire. Brightstone's accounting system indicates that the total cost per tire is as follows:
Direct materials | $42 |
Direct labor | 16 |
Factory overhead (70% variable) | 26 |
Selling and administrative expenses (40% variable) | 22 |
Total | $106 |
Brightstone pays a selling commission equal to 5% of the selling price on North American orders, which is included in the variable portion of the selling and administrative expenses. However, this special order would not have a sales commission. If the order was accepted, the tires would be shipped overseas for an additional shipping cost of $6 per tire. In addition, Euro has made the order conditional on receiving European safety certification. Brightstone estimates that this certification would cost $106,200.
a. Prepare a The area of accounting concerned with the effect of alternative courses of action on revenues and costs.differential analysis dated January 21 on whether to reject (Alternative 1) or accept (Alternative 2) the special order from Euro Motors. If an amount is zero, enter zero "0". If required, round interim calculations to two decimal places.
Differential Analysis | |||
Reject Order (Alt. 1) or Accept Order (Alt. 2) | |||
January 21 | |||
Reject Order (Alternative 1) |
Accept Order (Alternative 2) |
Differential Effect on Income (Alternative 2) |
|
Revenues | $ | $ | $ |
Costs: | |||
Direct materials | |||
Direct labor | |||
Variable factory overhead | |||
Variable selling and admin. expenses | |||
Shipping costs | |||
Certification costs | |||
Income (Loss) | $ | $ | $ |
Feedback
Determine whether to reject (Alternative 1) or accept
(Alternative 2) the special order from Euro Motors.
b. What is the minimum price per unit that
would be financially acceptable to Brightstone? Round your answer
to two decimal places.
$per unit
In: Accounting
Awesome Products Company manufactures a product sold to retailers. It is considering suppliers for its process. The supplier quality involves four activity areas:
Activity Area | Cost Driver and Rate |
Order cost | $120 per purchase order |
Defective units | $200 per unit internal failure costs |
Delivery trips | $5 per delivery |
Carrying cost | $1 per order |
The following supplier information is given:
X3 | Y2 | Z1 | |
Materials units needed | 100,000 | 100,000 | 100,000 |
Actual purchase price | $5 | $4.99 | $5.01 |
Number of purchase orders | 20 | 30 | 18 |
Number of defects | 6 | 12 | 0 |
Number of deliveries | 20 | 30 | 18 |
Which supplier is least costly?
a.Y2
b.Z1
c.X3
d.They are equally costly.
Awesome Products Company manufactures a product sold to retailers. It is considering suppliers for its process. The supplier quality involves four activity areas:
Activity Area | Cost Driver and Rate |
Order cost | $120 per purchase order |
Defective units | $200 per unit internal failure costs |
Delivery trips | $5 per delivery |
Carrying cost | $1 per order |
The following supplier information is given:
X3 | Y2 | Z1 | |
Materials units needed | 100,000 | 100,000 | 100,000 |
Actual purchase price | $5 | $4.99 | $5.01 |
Number of purchase orders | 20 | 30 | 18 |
Number of defects | 6 | 12 | 0 |
Number of deliveries | 20 | 30 | 18 |
Which supplier is least costly?
a.Y2
b.Z1
c.X3
d.They are equally costly.
In: Accounting
The following inventory transactions occurred at Zinc, Inc., which uses a perpetual inventory system:
October 2 Purchased 50 units of inventory from supplier on credit. The goods cost $30 each and the credit terms were 2/10, n/30. The shipping costs were $100 under the terms FOB destination and Zinc received the inventory on October 3rd.
October 4 Returned 5 units of inventory from the October 2nd transaction to to the supplier.
October 6 Sold 15 of the units purchased on October 2nd for $50 each to customers for cash.
October 7 Accepted a return of one unit of inventory from an October 6th customer for a cash refund.
October 10 Established a petty cash fund for $300.
October 11 Paid the supplier for one-half of the inventory purchased on October 2nd, net of any returns.
October 15 Used $20 out of petty cash to pay for stamps (postage expense).
October 28 Purchased 10 units of inventory from a supplier on credit. The good cost #25 each and no credit terms were granted. The shipping costs were $50 under the terms FOB destination and Zinc received the inventory on November 2.
October 30 Paid the remaining balance owed to the supplier from the October 2nd transaction.
October 31 Replenished petty cash.
Using the space provided below and on the next page, record the appropriate journal entries for these transactions with the appropriate date (no journal entry description is required). Include only journal entries that relate to October business. If no journal entry is needed, write the transaction date and NO Entry.
In: Accounting
Several years ago, Westmont Corporation developed a comprehensive budgeting system for planning and control purposes. While departmental supervisors have been happy with the system, the factory manager has expressed considerable dissatisfaction with the information being generated by the system.
A report for the company's Assembly Department for the month of March follows:
Assembly Department Cost Report For the Month Ended March 31 |
|||||||
Actual Results | Planning Budget | Variances | |||||
Machine-hours | 15,000 | 20,000 | |||||
Variable costs: | |||||||
Supplies | $ | 10,500 | $ |
11,100 |
$ | 600 | F |
Scrap | 37,800 | 40,500 | 2,700 | F | |||
Indirect materials | 108,200 | 129,000 | 20,800 | F | |||
Fixed costs: | |||||||
Wages and salaries | 82,300 | 77,000 | 5,300 |
U |
|||
Equipment depreciation | 107,000 | 107,000 | – | ||||
Total cost | $ | 345,800 | $ | 364,600 | $ | 18,800 | F |
After receiving a copy of this cost report, the supervisor of the
Assembly Department stated, “These reports are super. It makes me
feel really good to see how well things are going in my department.
I can’t understand why those people upstairs complain so much about
the reports.”
For the last several years, the company’s marketing department has chronically failed to meet the sales goals expressed in the company’s monthly budgets.
Required:
1. The company’s president is uneasy about the cost reports, identify at least two reasons.
2. What kind of reports should be used to give better insight into how well departmental supervisors are controlling costs?
3. Complete the new performance report for the quarter, based on Flexible Budget Performance approach.
4. Were costs well controlled in March?
The company’s president is uneasy about the cost reports, identify at least two reasons. (Select "X" if the item is one of the reasons.)
|
What changes, if any, should be made in the reports to give better insight into how well departmental supervisors are controlling costs?
|
prepare a new performance report for the quarter, (Do not round your intermediate calculations. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
|
How well were costs controlled in the Assembly Department in March?
|
In: Accounting
Creative Computing sells a tablet computer called the Protab.
The $970 sales price of a Protab Package includes the
following:
Required:
1. & 2. Indicate below whether each item is a
separate performance obligation and allocate the transaction price
of 80,000 Protab Packages to the separate performance obligations
in the contract.
3. Prepare a journal entry to record sales of
80,000 Protab Packages (ignore any sales of extended
warranties).
In: Accounting
You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door opening device. The president has asked that you review the company’s costing system and “do what you can to help us get better control of our manufacturing overhead costs.” You find that the company has never used a flexible budget, and you suggest that preparing such a budget would be an excellent first step in overhead planning and control.
After much effort and analysis, you determined the following cost formulas and gathered the following actual cost data for March:
Cost Formula | Actual Cost in March | ||
Utilities | $16,500 plus $0.13 per machine-hour | $ | 20,770 |
Maintenance | $38,500 plus $1.70 per machine-hour | $ | 64,600 |
Supplies | $0.90 per machine-hour | $ | 16,900 |
Indirect labor | $94,900 plus $1.90 per machine-hour | $ | 131,900 |
Depreciation | $68,500 | $ | 70,200 |
During March, the company worked 17,000 machine-hours and produced 11,000 units. The company had originally planned to work 19,000 machine-hours during March.
Required:
1. Calculate the activity variances for March.
2. Calculate the spending variances for March.
Calculate the activity variances for March. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
|
Calculate the spending variances for March. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
|
In: Accounting
Case 9-31 Master Budget with Supporting Schedules [LO9-2, LO9-4, LO9-8, LO9-9, LO9-10]
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash.
Since you are well trained in budgeting, you have decided to prepare comprehensive budgets for the upcoming second quarter in order to show management the benefits that can be gained from an integrated budgeting program. To this end, you have worked with accounting and other areas to gather the information assembled below.
The company sells many styles of earrings, but all are sold for the same price—$18 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings):
January (actual) | 22,800 | June (budget) | 52,800 |
February (actual) | 28,800 | July (budget) | 32,800 |
March (actual) | 42,800 | August (budget) | 30,800 |
April (budget) | 67,800 | September (budget) | 27,800 |
May (budget) | 102,800 | ||
The concentration of sales before and during May is due to Mother’s Day. Sufficient inventory should be on hand at the end of each month to supply 40% of the earrings sold in the following month.
Suppliers are paid $5.4 for a pair of earrings. One-half of a month’s purchases is paid for in the month of purchase; the other half is paid for in the following month. All sales are on credit, with no discount, and payable within 15 days. The company has found, however, that only 20% of a month’s sales are collected in the month of sale. An additional 70% is collected in the following month, and the remaining 10% is collected in the second month following sale. Bad debts have been negligible.
Monthly operating expenses for the company are given below:
Variable: | |||
Sales commissions | 4% | of sales | |
Fixed: | |||
Advertising | $ | 340,000 | |
Rent | $ | 32,000 | |
Salaries | $ | 134,000 | |
Utilities | $ | 14,000 | |
Insurance | $ | 4,400 | |
Depreciation | $ | 28,000 | |
Insurance is paid on an annual basis, in November of each year.
The company plans to purchase $23,000 in new equipment during May and $54,000 in new equipment during June; both purchases will be for cash. The company declares dividends of $25,500 each quarter, payable in the first month of the following quarter.
A listing of the company’s ledger accounts as of March 31 is given below:
Assets | ||
Cash | $ | 88,000 |
Accounts receivable ($51,840 February sales;$616,320 March sales) | 668,160 | |
Inventory | 146,448 | |
Prepaid insurance | 28,000 | |
Property and equipment (net) | 1,090,000 | |
Total assets | $ | 2,020,608 |
Liabilities and Stockholders’ Equity | ||
Accounts payable | $ | 114,000 |
Dividends payable | 25,500 | |
Common stock | 1,080,000 | |
Retained earnings | 801,108 | |
Total liabilities and stockholders’ equity | $ | 2,020,608 |
The company maintains a minimum cash balance of $64,000. All borrowing is done at the beginning of a month; any repayments are made at the end of a month.
The company has an agreement with a bank that allows the company to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. At the end of the quarter, the company would pay the bank all of the accumulated interest on the loan and as much of the loan as possible (in increments of $1,000), while still retaining at least $64,000 in cash.
Required:
1. Prepare a master budget for the three-month period ending June 30. Include the following detailed budgets:
a. A sales budget, by month and in total.
Sales | Budget | |||
---|---|---|---|---|
April | May | June | Quarter | |
Budget Unit Sales | ||||
Selling Price peer unit | ||||
Total Sales |
b. A schedule of expected cash collections from sales, by month and in total.
Earrings Unlimited | ||||
---|---|---|---|---|
Schedule of Expected Cash Collections | ||||
April | May | June | Quarter | |
February Sales | ||||
March Sales | ||||
April Sales | ||||
May Sales | ||||
June Sales | ||||
Total Cash Collections |
c. A merchandise purchases budget in units and in dollars. Show the budget by month and in total. (Round unit cost of purchases to 1 decimal place.)
Earrings Unlimited | ||||
---|---|---|---|---|
Merchandise Purchases Budget | ||||
April | May | June | Quarter | |
Budgeted Unit Sales | ||||
?? | ||||
Total Needs | ||||
?? | ||||
Required Purchases | ||||
Unit Cost | ||||
Required Dollar Purchases |
d. d. A schedule of expected cash disbursements for merchandise purchases, by month and in total.
Earrings Unlimited | ||||
---|---|---|---|---|
Budgeted Cash Disbursements for Merchandise Purchases | ||||
April |
May | June | Quarter | |
Accounts Payable |
||||
April Purchases |
||||
May Purchases |
||||
June Purchases |
||||
Total Cash Payments |
In: Accounting
189. Caitlin, Chris, and Molly are partners and share income and losses in a 3:4:3 ratio. The partnership’s capital balances are Caitlin, $137,000; Chris, $97,000; and Molly, $117,000. Paul is admitted to the partnership on July 1 with a 20% equity and invests $77,000. The balance in Caitlin’s capital account immediately after Paul’s admission is:
$139,580
$134,420
$77,000
$85,600
$137,000
195. Martin Company purchases a machine at the beginning of the year at a cost of $69,000. The machine is depreciated using the straight-line method. The machine’s useful life is estimated to be 5 years with a $6,000 salvage value. The book value of the machine at the end of year 5 is:
$27,600.
$12,600.
$6,000.
$63,000.
$0.
In: Accounting
In: Accounting
The assignment is to imagine yourself 10 years in the future. I'm basing my salary off the average financial adviser for myself and a school teacher for my wife. (PA). Me $ 76,035 Her $62,260. I need to make a budget.
Personal and Family Expenses
Category |
Monthly Budget |
|
Current |
Alternative 1 / Retirement |
|
Alimony |
$ |
$ |
Bank Charges |
$ |
$ |
Books/Magazines |
$ |
$ |
Business Expense |
$ |
$ |
Care of Parent/Other |
$ |
$ |
Cash — Miscellaneous |
$ |
$ |
Cell Phone |
$ |
$ |
Charitable Donations |
$ |
$ |
Child Activities |
$ |
$ |
Child Allowance/Expense |
$ |
$ |
Child Care |
$ |
$ |
Child Support |
$ |
$ |
Child school help |
$ |
$ |
Clothing — Client |
$ |
$ |
Clothing — Co-Client |
$ |
$ |
Clothing — Children |
$ |
$ |
Club Dues |
$ |
$ |
Credit Card Debt |
$ |
$ |
Dining |
$ |
$ |
Personal and Family Expenses (continued)
Category |
Monthly Budget |
|
Current |
Alternative 1 / Retirement |
|
Entertainment |
$ |
$ |
Gifts |
$ |
$ |
Groceries |
$ |
$ |
Health Care - Dental |
$ |
$ |
Health Care - Medical |
$ |
$ |
Health Care - Prescription |
$ |
$ |
Hobbies |
$ |
$ |
Household Items |
$ |
$ |
Laundry/Dry Cleaning |
$ |
$ |
Personal Care |
$ |
$ |
Personal Loan Payment |
$ |
$ |
Pet Care |
$ |
$ |
Public Transportation |
$ |
$ |
Recreation |
$ |
$ |
Self Improvement |
$ |
$ |
Student Loan |
$ |
$ |
Vacation/Travel |
$ |
$ |
Other: |
$ |
$ |
$ |
$ |
In: Accounting
High-Low Method. Castanza Company produces computer printers. Management wants to estimate the cost of production equipment used to produce printers. The company reported the following monthly cost data related to production equipment:
Reporting Period (Month) | Total Costs | Machine Hours |
January | $ 920,000 | 45,000 |
February | 600,000 | 25,000 |
March | 500,000 | 20,000 |
April | 1,100,000 | 90,000 |
May | 1,140,000 | 95,000 |
June | 620,000 | 30,000 |
July | 880,000 | 38,000 |
August | 910,000 | 48,000 |
September | 1,060,000 | 78,000 |
October | 960,000 | 51,000 |
November | 1,400,000 | 96,000 |
December | 980,000 | 54,000 |
Required:
In: Accounting
Creative Computing sells a tablet computer called the Protab. The $970 sales price of a Protab Package includes the following: One Protab computer. A 6-month limited warranty. This warranty guarantees that Creative will cover any costs that arise due to repairs or replacements associated with defective products for up to six months. A coupon to purchase a Creative Probook e-book reader for $200, a price that represents a 50% discount from the regular Probook price of $400. It is expected that 25% of the discount coupons will be utilized. A coupon to purchase a one-year extended warranty for $70. Customers can buy the extended warranty for $70 at other times as well. Creative estimates that 35% of customers will purchase an extended warranty. Creative does not sell the Protab without the limited warranty, option to purchase a Probook, and the option to purchase an extended warranty, but estimates that if it did so, a Protab alone would sell for $950. All Protab sales are made in cash. Required: 1. & 2. Indicated below whether each item is a separate performance obligation and allocate the transaction price of 90,000 Protab Packages to the separate performance obligations in the contract. 3. Prepare a journal entry to record sales of 90,000 Protab Packages (ignore any sales of extended warranties).
In: Accounting
Average Rate of Return Method, Net Present Value Method, and Analysis
The capital investment committee of Ellis Transport and Storage Inc. is considering two investment projects. The estimated income from operations and net cash flows from each investment are as follows:
Warehouse | Tracking Technology | |||||||||
Year | Income from Operations |
Net Cash Flow |
Income from Operations |
Net Cash Flow |
||||||
1 | $36,100 | $118,000 | $76,000 | $189,000 | ||||||
2 | 36,100 | 118,000 | 58,000 | 159,000 | ||||||
3 | 36,100 | 118,000 | 29,000 | 112,000 | ||||||
4 | 36,100 | 118,000 | 13,000 | 77,000 | ||||||
5 | 36,100 | 118,000 | 4,500 | 53,000 | ||||||
Total | $180,500 | $590,000 | $180,500 | $590,000 |
Each project requires an investment of $380,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate of 15% for purposes of the net present value analysis.
Present Value of $1 at Compound Interest | |||||
Year | 6% | 10% | 12% | 15% | 20% |
1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
2 | 0.890 | 0.826 | 0.797 | 0.756 | 0.694 |
3 | 0.840 | 0.751 | 0.712 | 0.658 | 0.579 |
4 | 0.792 | 0.683 | 0.636 | 0.572 | 0.482 |
5 | 0.747 | 0.621 | 0.567 | 0.497 | 0.402 |
6 | 0.705 | 0.564 | 0.507 | 0.432 | 0.335 |
7 | 0.665 | 0.513 | 0.452 | 0.376 | 0.279 |
8 | 0.627 | 0.467 | 0.404 | 0.327 | 0.233 |
9 | 0.592 | 0.424 | 0.361 | 0.284 | 0.194 |
10 | 0.558 | 0.386 | 0.322 | 0.247 | 0.162 |
Required:
1a. Compute the average rate of return for each investment. If required, round your answer to one decimal place.
Average Rate of Return | |
Warehouse | % |
Tracking Technology | % |
1b. Compute the net present value for each investment. Use the present value of $1 table above. If required, use the minus sign to indicate a negative net present value.
Warehouse | Tracking Technology | |
Present value of net cash flow total | $ | $ |
Less amount to be invested | $ | $ |
Net present value | $ | $ |
2. The warehouse has a net present value as tracking technology cash flows occur in time. Thus, if only one of the two projects can be accepted, the would be the more attractive.
In: Accounting
NUMBER THREE:
The financial statements for Castile Products, Inc., are given below:
Castile Products, Inc. |
||||||
Assets |
||||||
Current assets: |
||||||
Cash |
$ |
22,000 |
||||
Accounts receivable, net |
180,000 |
|||||
Merchandise inventory |
380,000 |
|||||
Prepaid expenses |
7,000 |
|||||
Total current assets |
589,000 |
|||||
Property and equipment, net |
820,000 |
|||||
Total assets |
$ |
1,409,000 |
||||
Liabilities and Stockholders' Equity |
||||||
Liabilities: |
||||||
Current liabilities |
$ |
220,000 |
||||
Bonds payable, 10% |
380,000 |
|||||
Total liabilities |
600,000 |
|||||
Stockholders’ equity: |
||||||
Common stock, $5 par value |
$ |
150,000 |
||||
Retained earnings |
659,000 |
|||||
Total stockholders’ equity |
809,000 |
|||||
Total liabilities and stockholders’ equity |
$ |
1,409,000 |
||||
Castile Products, Inc. |
|||
Sales |
$ |
3,700,000 |
|
Cost of goods sold |
1,276,500 |
||
Gross margin |
2,423,500 |
||
Selling and administrative expenses |
610,000 |
||
Net operating income |
1,813,500 |
||
Interest expense |
38,000 |
||
Net income before taxes |
1,775,500 |
||
Income taxes (30%) |
532,650 |
||
Net income |
$ |
1,242,850 |
|
Account balances at the beginning of the year were: accounts receivable, $190,000; and inventory, $310,000. All sales were on account.
Required:
Compute the following financial data and ratios:
1. Working capital.
2. Current ratio. (Round your answer to 1 decimal place.)
3. Acid-test ratio. (Round your answer to 2 decimal places.)
4. Debt-to-equity ratio. (Round your answer to 2 decimal places.)
5. Times interest earned ratio. (Round your answer to 2 decimal places.)
6. Average collection period. (Use 365 days in a year. Round your intermediate calculations and final answer to 1 decimal place.)
7. Average sale period. (Use 365 days in a year. Round your intermediate calculations and final answer to 1 decimal place.)
8. Operating cycle. (Round your intermediate calculations and final answer to 1 decimal place.)
In: Accounting
Tolson Company purchased a building by paying $85,000. The building has an estimated life of 40 years and an estimated residual value of $5,000.
Required:
Prepare journal entries to record the purchase and the related year-end adjusting entry. |
In: Accounting