Tidewater Company uses the product cost concept of applying the cost-plus approach to product pricing. The cost and expenses of producing and selling 50,000 units of Product K are as follows:
| Variable costs: | |
| Direct materials | $5.00 |
| Direct labor | 8.50 |
| Factory overhead | 2.50 |
| Selling and administrative expenses | 1.00 |
| Total | $17.00 |
| Fixed costs: | |
| Factory overhead | $50,000 |
| Selling and administrative expenses | 34,000 |
Tidewater desires a profit equal to a 10% rate of return on invested assets of $1,285,000.
a. Determine the amount of desired profit from
the production and sale of Product K.
$ 128,500
b. Determine the total manufacturing costs and the cost amount per unit for the production and sale of 50,000 units of Product K.
| Total manufacturing costs | $850,000 |
| Cost amount per unit | $17 |
c. Determine the markup percentage for Product
K.
%
d. Determine the selling price of Product K.
Round your answer to two decimal places.
$21.25
I'm having trouble with C.
In: Accounting
|
Pittman Company is a small but growing manufacturer of telecommunications equipment. The company has no sales force of its own; rather, it relies completely on independent sales agents to market its products. These agents are paid a sales commission of 15% for all items sold. |
|
Barbara Cheney, Pittman’s controller, has just prepared the company’s budgeted income statement for next year. The statement follows: |
| Pittman Company Budgeted Income Statement For the Year Ended December 31 |
||||
| Sales | $ | 16,000,000 | ||
| Manufacturing expenses: | ||||
| Variable | $ | 7,200,000 | ||
| Fixed overhead | 2,340,000 | 9,540,000 | ||
| Gross margin | 6,460,000 | |||
| Selling and administrative expenses: | ||||
| Commissions to agents | 2,400,000 | |||
| Fixed marketing expenses | 120,000* | |||
| Fixed administrative expenses | 1,800,000 | 4,320,000 | ||
| Net operating income | 2,140,000 | |||
| Fixed interest expenses | 540,000 | |||
| Income before income taxes | 1,600,000 | |||
| Income taxes (30%) | 480,000 | |||
| Net income | $ | 1,120,000 | ||
| *Primarily depreciation on storage facilities. | ||||
|
As Barbara handed the statement to Karl Vecci, Pittman’s president, she commented, “I went ahead and used the agents’ 15% commission rate in completing these statements, but we’ve just learned that they refuse to handle our products next year unless we increase the commission rate to 20%.” |
|
“That’s the last straw,” Karl replied angrily. “Those agents have been demanding more and more, and this time they’ve gone too far. How can they possibly defend a 20% commission rate?” |
|
“They claim that after paying for advertising, travel, and the other costs of promotion, there’s nothing left over for profit,” replied Barbara. |
|
“I say it’s just plain robbery,” retorted Karl. “And I also say it’s time we dumped those guys and got our own sales force. Can you get your people to work up some cost figures for us to look at?” |
|
“We’ve already worked them up,” said Barbara. “Several companies we know about pay a 7.5% commission to their own salespeople, along with a small salary. Of course, we would have to handle all promotion costs, too. We figure our fixed expenses would increase by $2,400,000 per year, but that would be more than offset by the $3,200,000 (20% × $16,000,000) that we would avoid on agents’ commissions.” |
| The breakdown of the $2,400,000 cost follows: |
| Salaries: | |||
| Sales manager | $ | 100,000 | |
| Salespersons | 600,000 | ||
| Travel and entertainment | 400,000 | ||
| Advertising | 1,300,000 | ||
| Total | $ | 2,400,000 | |
|
“Super,” replied Karl. “And I noticed that the $2,400,000 is just what we’re paying the agents under the old 15% commission rate.” |
|
“It’s even better than that,” explained Barbara. “We can actually save $75,000 a year because that’s what we’re having to pay the auditing firm now to check out the agents’ reports. So our overall administrative expenses would be less.” |
|
“Pull all of these numbers together and we’ll show them to the executive committee tomorrow,” said Karl. “With the approval of the committee, we can move on the matter immediately.” |
| Required: | |
| 1. |
Compute Pittman Company’s break-even point in dollar sales for next year assuming: (Enter your answer in whole dollars and not in thousands. Round CM ratio to 3 decimal places and final answer to the nearest dollar amount.) |
| a. |
The agents’ commission rate remains unchanged at 15%. |
| b. |
The agents’ commission rate is increased to 20%. |
| c. |
The company employs its own sales force. |
| 2. |
Assume that Pittman Company decides to continue selling through agents and pays the 20% commission rate. Determine the volume of sales that would be required to generate the same net income as contained in the budgeted income statement for next year. (Enter your answer in whole dollars and not in thousands. Round CM ratio to 2 decimal places.) |
| 3. |
Determine the volume of sales at which net income would be equal regardless of whether Pittman Company sells through agents (at a 20% commission rate) or employs its own sales force. (Enter your answer in whole dollars and not in thousands. Round CM ratio to 3 decimal places.) |
| 4. |
Compute the degree of operating leverage that the company would expect to have on December 31 at the end of next year assuming: |
| a. |
The agents’ commission rate remains unchanged at 15%. |
| b. |
The agents’ commission rate is increased to 20%. |
| c. | The company employs its own sales force. |
In: Accounting
On January 1, 2015 $20,000,000 of 20 year bonds were issued with a coupon rate of 6.5% when the market rate was 6%. Interest is paid every six months on June 30th and December 31st. Prepare the following journal entries and show your calculations as to how you arrived at the numbers.
1)Issuance of bonds on January 1, 2015
2) Payment of interest on June 30th and December 31st of both 2015 and 2016.
3) What is the carrying value of the bonds that would be presented on the balance sheet at December 31st 2016.
In: Accounting
Sonic Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget:
| Rumble | Thunder | ||
| Estimated inventory (units), June 1 | 260 | 64 | |
| Desired inventory (units), June 30 | 299 | 56 | |
| Expected sales volume (units): | |||
| Midwest Region | 3,650 | 3,200 | |
| South Region | 4,900 | 4,250 | |
| Unit sales price | $145 | $185 |
a. Prepare a sales budget.
| Sonic Inc. | |||
| Sales Budget | |||
| For the Month Ending June 30 | |||
| Product and Area | Unit Sales Volume | Unit Selling Price | Total Sales |
| Model: Rumble | |||
| Midwest Region | $ | $ | |
| South Region | |||
| Total | $ | ||
| Model: Thunder | |||
| Midwest Region | $ | $ | |
| South Region | |||
| Total | $ | ||
| Total revenue from sales | $ | ||
b. Prepare a production budget. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
| Sonic Inc. | ||
| Production Budget | ||
| For the Month Ending June 30 | ||
| Units Rumble | Units Thunder | |
| Expected units to be sold | ||
| Desired inventory, June 30 | ||
| Total units available | ||
| Estimated inventory, June 1 | ||
| Total units to be produced | ||
In: Accounting
Gladstone Company tracks the number of units purchased and sold
throughout each accounting period but applies its inventory costing
method at the end of each period, as if it uses a periodic
inventory system. Assume its accounting records provided the
following information at the end of the annual accounting period,
December 31.
| Transactions | Units | Unit Cost | |||||||
| Beginning inventory, January 1 | 1,600 | $ | 40 | ||||||
| Transactions during the year: | |||||||||
| a. | Purchase, January 30 | 3,650 | 54 | ||||||
| b. | Sale, March 14 ($100 each) | (2,000 | ) | ||||||
| c. | Purchase, May 1 | 2,350 | 70 | ||||||
| d. | Sale, August 31 ($100 each) | (2,500 | ) | ||||||
Assuming that for Specific identification method (item 1d) the
March 14 sale was selected two-fifths from the beginning inventory
and three-fifths from the purchase of January 30. Assume that the
sale of August 31 was selected from the remainder of the beginning
inventory, with the balance from the purchase of May 1.
Required:
Last-in, first-out
Weighted average cost
First-in, first-out
Specific identification
Last-in, first-out
Weighted average cost
First-in, first-out
Specific identification
In: Accounting
Cash Budget
The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budgetinformation:
| September | October | November | ||||
| Sales | $146,000 | $181,000 | $232,000 | |||
| Manufacturing costs | 61,000 | 78,000 | 84,000 | |||
| Selling and administrative expenses | 51,000 | 54,000 | 88,000 | |||
| Capital expenditures | _ | _ | 56,000 | |||
The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $7,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month.
Current assets as of September 1 include cash of $55,000, marketable securities of $79,000, and accounts receivable of $163,100 ($128,000 from July sales and $35,100 from August sales). Sales on account for July and August were $117,000 and $128,000, respectively. Current liabilities as of September 1 include $7,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $22,000 will be made in October. Bridgeport’s regular quarterly dividend of $7,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of $54,000.
Required:
1. Prepare a monthly cash budget and supporting schedules for September, October, and November. Input all amounts as positive values except overall cash decrease and deficiency which should be indicated with a minus sign. Assume 360 days per year for interest calculations.
| Bridgeport Housewares Inc. | |||
| Cash Budget | |||
| For the Three Months Ending November 30 | |||
| September | October | November | |
| Estimated cash receipts from: | |||
| Cash sales | $ | $ | $ |
| Collection of accounts receivable | |||
| Total cash receipts | $ | $ | $ |
| Less estimated cash payments for: | |||
| Manufacturing costs | $ | $ | $ |
| Selling and administrative expenses | |||
| Capital expenditures | |||
| Other purposes: | |||
| Income tax | |||
| Dividends | |||
| Total cash payments | $ | $ | $ |
| Cash increase or (decrease) | $ | $ | $ |
| Plus cash balance at beginning of month | |||
| Cash balance at end of month | $ | $ | $ |
| Less minimum cash balance | |||
| Excess or (deficiency) | |||
In: Accounting
Projected benefit obligation 1/1/17- $560,000
Plan Assets 1/1/17- $546,200
On 1/2017, Ludell amends the plan and grants prior service cost benefits of $120,000
Settlement rate - 9% Service Cost - $58,000 Contribution - $65,000
Actual/expected returns-$52,280 Benefits paid-$40,000
PSC amortization-$17,000.
A. Prepare the pension worksheet showing the journal entry for pension expense.
B. Show Y/E balances in the pension accounts (Memo record and OCI accounts included) C. Indicate amounts to be reported on Balance sheet and Income statements.
In: Accounting
Allocation: Fixed and Variable Costs, Budgeted Fixed and Variable Costs
Biotechtron, Inc., has two research laboratories in the Southwest, one in Yuma, Arizona, and the other in Bernalillo, New Mexico. The owner of Biotechtron centralized the legal services function in the Yuma office and had both laboratories send any legal questions or issues to the Yuma office. The legal services support center has budgeted fixed costs of $175,000 per year and a budgeted variable rate of $66 per hour of professional time. The normal usage of the legal services center is 2,925 hours per year for the Yuma office and 1,575 hours per year for the Bernalillo office. This corresponds to the expected usage for the coming year.
Required:
1. Determine the amount of legal services support center costs that should be assigned to each office. In your computations, carry ratio values out to two decimal places. Round your final answers to the nearest dollar if rounding is required.
2. Since the offices produce services, not tangible products, what purpose is served by allocating the budgeted costs?
3. Now, assume that during the year, the legal services center incurred actual fixed costs of $178,300 and actual variable costs of $254,740. It delivered 3,840 hours of professional time—2,270 hours to Yuma and 1,570 hours to Bernalillo.
Determine the amount of the legal services center's costs that should be allocated to each office.
In: Accounting
Fill in the missing amounts in the following schedules.
|
|
Fill in the missing amounts in the following schedules.
|
|
|
*Half of each month’s sales are on account. March sales amounted to $186,000.
†60% of credit sales is collected in the month of sale; 40% is collected in the following month.
‡Yen is the Japanese national currency.
In: Accounting
In: Accounting
In: Accounting
McKinsey Machines Ltd manufactures a single product A. It has two cost centers namely molding department and painting department.
|
Information |
Molding Department |
Painting Department |
|
Total Manufacturing overheads |
$ 1,806,000 |
$ 2,205,000 |
|
Total Machine hours (estimated) |
210,000 |
|
|
Total Direct Labour Cost |
$ 1,260,000 |
McKinsey Ltd executes job no. 410. The cost and output details of Job No.410 are given below:
|
Information |
Molding Department |
Painting Department |
|
Direct Materials |
$ 1,410 |
$ 996 |
|
Direct Labour |
$ 870 |
$ 2,040 |
|
Number of machine hours used in job no. 410 |
330 hours |
|
|
Output (units) (expected to be received from Job No. 410) |
150 units |
|
Overheads allocation to Job No. 410 will be as follows:
(a) Molding department overheads will be allocated based on machine hours
(b) Painting Department overheads will be allocated using direct labour costs (as a percentage).
Required
(4) Explain why the costs reported under traditional costing and activity-based costing differ from one another?
In: Accounting
Admire is a retail company that sells specialized gardening products. The company is considering opening a new store on October 1, Year1. As budget coordinator, you have been asked to prepare a master budget for the first 3 months of the company’s operation. You have gathered the following information:
October sales are estimated to be $300000 of which 45 percent will be cash and the remainder will be on credit. The company expects all sales to increase at the rate of 20 percent per month for November and December. Sales in January Year 2 are expected to be $250000.
The company expects to collect 100 percent of the accounts receivable generated by credit sales in the month following the sale.
Prepare a sales budget and a schedule of cash receipts using these facts and your excel template. Check your answers here before moving to the next part, by completing the cells requested in the chart below.
| a. Sales Budget | October | November | December | Total-Qtr |
| Cash sales | ||||
| Sales on account | ||||
| Total budgeted sales |
| b. Schedule of Cash Receipts | October | November | December | Total-Qtr |
| Current cash sales | ||||
| Plus collections from A/R | ||||
| Total collections |
The cost of goods sold is 60 percent of sales. The company desires to maintain a minimum ending inventory equal to 10 percent of the next month’s cost of goods sold. (Ending inventory for December is based on budgeted January Year2 sales.)
Assume that all inventory purchases are made on account (on credit). The company pays 80 percent of accounts payable in the month of purchase and the remaining amount in the following month.
In excel, prepare an inventory purchases budget and a cash payments budget for inventory purchases. Use the check figures below before you continue.
| c. Inventory Purchases Budget | October | November | December | Total-Qtr |
| Budgeted cost of goods sold | ||||
| Plus desired ending inventory | ||||
| Inventory needed | ||||
| Less beginning inventory | ||||
| Required purchases (on account) |
| d. Cash payments for inventory | October | November | December | Total-Qtr |
| Payment of current month's A/P | ||||
| Payment for prior month's A/P | ||||
| Total budgeted payments |
Budgeted selling and administrative expenses per month follow.
*The capital expenditures budget indicates that the company will spend $182400 on October 1 for store fixtures, which are expected to have a $24000 residual value and a 36 month useful life.
Utilities and sales commissions are paid the month after they are incurred; all other expenses are paid in the month in which they are incurred.
In excel, prepare the selling and administrative expenses budget and the cash payments budget for selling and administrative expenses. Check the key figures below.
| e. Selling and Admin.Expense Budget | October | November | December | Total-Qtr |
| Salary expense | ||||
| Sales commissions | ||||
| Supplies expense | ||||
| Utilities | ||||
| Depreciation on store fixtures | ||||
| Rent | ||||
| Miscellaneous | ||||
| Total S&A expenses |
| f. Cash payments for S&A | October | November | December | Total-Qtr |
| Salary expense | ||||
| Sales commissions | ||||
| Supplies expense | ||||
| Utilities | ||||
| Depreciation on store fixtures | ||||
| Rent | ||||
| Miscellaneous | ||||
| Total payments for S&A expenses |
Admire issued common stock for $50000 on October 5.
A dividend of $28000 was paid on December 15.
The company borrows and repays funds in increments of $1,000 on the last day of the month. The company also pays its vendors on the last day of the month. It pays interest of 1 percent per month in cash on the last day of the month. To be prudent, the company desires to maintain a $16000 cash cushion.
Prepare a cash budget on your excel template. Check key figure below.
| g. Cash Budget | October | November | December | Total-Qtr |
| Beginning cash balance | ||||
| Issuance of stock | ||||
| Collections from customers | ||||
| Cash available | ||||
| Less payments | ||||
| For inventory purchases | ||||
| For S&A expenses | ||||
| Purchase of store fixtures | ||||
| Pay dividend | ||||
| Interest expense | ||||
| Total budgeted payments | ||||
| Cash balance before borrow/repay | ||||
| Financing activity | ||||
| Borrowing (repayment) | ||||
| Ending cash balance |
Income statement
Input expenses as negatives. Use a minus sign in front of the number.
| Sales revenue | |
| Cost of goods sold | |
| Gross margin | |
| S&A expenses | |
| Operating income | |
| Interest expense | |
| Net income |
Balance Sheet
Enter any contra-assets as negative numbers. Use a minus sign.
| Assets | |
| Cash | |
| Accounts receivable | |
| Inventory | |
| Store fixtures | |
| Accumulated depreciation | |
| Total assets | |
| Liabilities | |
| Accounts payable | |
| Utilities payable | |
| Sales commissions payable | |
| Line of credit liability | |
| Total liabilities | |
| Equity | |
| Common stock | |
| Retained earnings | |
| Total equity | |
| Total liabilities and equity | |
In: Accounting
Required information
[The following information applies to the questions displayed below.]
The City of Lynnwood was recently incorporated and had the following transactions for the fiscal year ended December 31.
| Property taxes | $ | 1,935,000 | |
| Licenses and permits | 45,000 | ||
| User charges | 33,000 | ||
a. For each transaction number identify all of the fund and/or government-wide activity journals in which journal entries must be made. (Select all that apply.)
| General Fund | GF | |
| Capital projects fund | CPF | |
| Internal service fund | ISF | |
| Permanent fund | PF | |
| After School Fund (a special revenue fund) | SRF | |
| Enterprise fund | EF | |
| Governmental activities | GA | |
In: Accounting
Mary Tappin, an assistant Vice President at Galaxy Toys, was disturbed to find on her desk a memo from her boss, Gary Resnick, to the controller of the company. The memo appears below:
GALAXY TOYS INTERNAL MEMO
Sept 15
To: Harry Wilson, Controller
Fm: Gary Resnick, Executive Vice President
As you know, we won't start recording many sales until October when stores start accepting shipments from us for the Christmas season. Meanwhile, we are producing flat-out and are building up our finished goods inventories so that we will be ready to ship next month.
Unfortunately, we are in a bind right now since it looks like the net income for the quarter ending on Sept 30 is going to be pretty awful. This may get us in trouble with the bank since they always review the quarterly financial reports and may call in our loan if they don't like what they see. Is there any possibility that we could change the classification of some of our period costs to product costs--such as the rent on the finished goods warehouse?
Please let me know as soon as possible. The President is pushing for results.
Mary didn't know what to do about the memo. It wasn't intended for her, but its contents were alarming.
Required:
a. Why has Gary Resnick suggested reclassifying some period costs as product costs?
b. Why do you think Mary was alarmed about the memo?
In: Accounting