Cash Receipts
The sales budget for Perrier Inc. is forecasted as follows:

To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales:

• 60 percent in the month of sale.
• 20 percent in the month following sale.
• 15 percent in the second month following sale.
• 5 percent uncollectible.

The company gives a 2 percent cash discount for payments made by customers during the month of sale. The accounts receivable balance on April 30 is $22,000, of which $7,000 represents uncollected March sales and $15,000 represents uncollected April sales. Prepare a schedule of budgeted cash collections from sales for May, June, and July. Include a three-month summary of estimated cash collections.

Sitwell Corporation manufactures titanium and aluminum tennis racquets. Sitwell's total overhead costs consist of assembly costs and inspection costs. The following information is available:

Sitwell is considering switching from one overhead rate based on labor hours to activity-based costing.
Using activity-based costing, how much assembly cost is assigned to titanium racquets?

Cash Budget
Wilson's Retail Company is planning a cash budget for the next three months. Estimated sales revenue is as follows:

All sales are on credit; 60 percent is collected during the month of sale, and 40 percent is collected during the next month. Cost of goods sold is 70 percent of sales. Payments for merchandise sold are made in the month following the month of sale. Operating expenses total $41,000 per month and are paid during the month incurred. The cash balance on February 1 is estimated to be $20,000.

Prepare monthly cash budgets for February, March, and April.

Use negative signs only with beginning and ending cash balances, when appropriate. Do not use negative signs with disbursement answers.

On January 2, 2011, Jansing Corporation acquired a new machine with an estimated useful life of five years. The cost of the equipment was $40,000 with a residual value of $5,000.

a. Prepare a complete depreciation table under the two depreciation methods listed below.

1. Straight-line.

2. 200 percent declining-balance.

3. 150 percent declining-balance with a switch to straight-line when it will maximize depreciation

expense.

Which of the following is not a special journal:

- Sales journal.

- Purchases journal.

- Cash receipts journal.

- General journal.

- Cash disbursements journal.

Explain under what circumstances a net operating loss of a partnership can be carried over and applied against income of a partner even after the 20-year carryover period provided for net operating loss carryovers has expired.

Do some research to find the 2018 balance sheets for Macy’s and Nordstrom online. For each company, navigate to the company’s website, then scroll down to investors or investor relations, 2018 annual report, and locate their 2018 balance sheet.

Identify and describe the company’s three most significant accounts in the following areas:

• Current assets
• Long-term asset
• Current liabilities
• Long-term liabilities
• Stockholders’ equity

How do these two retailer’s balance sheets compare? Which company do you feel is healthier?

Developing a Master Budget for a Manufacturing Organization

Jacobs Incorporated manufactures a product with a selling price of $50 per unit. Units and monthly cost data follow:

Jacobs pays all bills in the month incurred. All sales are on account with 50 percent collected the month of sale and the balance collected the following month. There are no sales discounts or bad debts. Jacobs desires to maintain an ending finished goods inventory equal to 20 percent of the following month's sales and a raw materials inventory equal to 10 percent of the following month's production. January 1, 2014, inventories are in line with these policies. Actual unit sales for December and budgeted unit sales for January, February, and March of 2014 are as follows:

Additional information:

• The January 1 beginning cash is projected as $5,000.
• For the purpose of operational budgeting, units in the January 1 inventory of finished goods are valued at variable manufacturing cost.
• Each unit of finished product requires one unit of raw materials.
• Jacobs intends to pay a cash dividend of $10,000 in January.

NOTE: For the entire problem - do not use any negative signs with your answers unless appropriate for net income(loss) or ending balance.

(a) A production budget for January and February.

(b) A purchases budget in units for January.

(c) A manufacturing cost budget for January.

(d) A cash budget for January.

(e) A budgeted contribution income statement for January.

Access the EDGAR database (SEC.gov) and obtain the July 2018 form 10K filing (for the year ended May 31, 2018) for NIKE, Inc. Prepare a table that reports the gross margin ratios for NIKE, using the revenues and cost of goods sold data from NIKE's income statement for each of it's most recent three years. Analyze and comment on trend in its gross margin ratio. Use complete sentences and good grammar. Feel free to access the Management Discussion and Analysis in the 10K to see if management had anything to say about the trend. Earn 10 points if you complete all elements of the assignment. You may comment on another students submission but you are not required to do so.

Minden Company is a wholesale distributor of premium European chocolates. The company’s balance sheet as of April 30 is given below:

The company is in the process of preparing a budget for May and has assembled the following data:

1. Sales are budgeted at $256,000 for May. Of these sales, $76,800 will be for cash; the remainder will be credit sales. One-half of a month’s credit sales are collected in the month the sales are made, and the remainder is collected in the following month. All of the April 30 accounts receivable will be collected in May.

2. Purchases of inventory are expected to total $188,000 during May. These purchases will all be on account. Forty percent of all purchases are paid for in the month of purchase; the remainder are paid in the following month. All of the April 30 accounts payable to suppliers will be paid during May.

3. The May 31 inventory balance is budgeted at $83,000.

4. Selling and administrative expenses for May are budgeted at $91,500, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $4,000 for the month.

5. The note payable on the April 30 balance sheet will be paid during May, with $435 in interest. (All of the interest relates to May.)

6. New refrigerating equipment costing $7,000 will be purchased for cash during May.

7. During May, the company will borrow $23,100 from its bank by giving a new note payable to the bank for that amount. The new note will be due in one year.

Required:

1. Calculate the expected cash collections from customers for May.

2. Calculate the expected cash disbursements for merchandise purchases for May.

3. Prepare a cash budget for May.

4. Prepare a budgeted income statement for May.

5. Prepare a budgeted balance sheet as of May 31.

Orange Corp. has two divisions: Fruit and Flower. The following information for the past year is available for each division:

Orange has established a hurdle rate of 8 percent.

Required:
1-a. Compute each division’s return on investment (ROI) and residual income for last year.
1-b. Determine which manager seems to be performing better.
2. Suppose Orange is investing in new technology that will increase each division’s operating income by $132,000. The total investment required is $2,100,000, which will be split evenly between the two divisions. Calculate the ROI and residual income for each division after the investment is made.
3. Determine whether both managers will support the investment.

1. Flexible Budget for Assembly Department

Cabinaire Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it assembles filing cabinets in an Assembly Department. Assume the following information for the Assembly Department:

Prepare a flexible budget for 10,000, 13,000, and 15,000 filing cabinets for the month of March in the Assembly Department similar to Exhibit 5. Enter all amounts as positive numbers.

2.

Production Budget

Weightless Inc. produces a Bath and Gym version of its popular electronic scale. The anticipated unit sales for the scales by sales region are as follows:

The finished goods inventory estimated for October 1, for the Bath and Gym scale models is 1,800 and 2,600 units, respectively. The desired finished goods inventory for October 31 for the Bath and Gym scale models is 1,300 and 2,800 units, respectively.

Prepare a production budget for the small and large scales for the month ended October 31. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

3.

Sales and Production Budgets

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:

a. Prepare a sales budget.

b. Prepare a production budget. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

Hickory Company manufactures two products—13,000 units of Product Y and 5,000 units of Product Z. The company uses a plantwide overhead rate based on direct labor-hours. It is considering implementing an activity-based costing (ABC) system that allocates all of its manufacturing overhead to four cost pools. The following additional information is available for the company as a whole and for Products Y and Z:

1. What is the company’s plantwide overhead rate

2. Using the plantwide overhead rate, how much manufacturing overhead cost is allocated to Product Y and Product Z?

3. What is the activity rate for the Machining activity cost pool?

4. What is the activity rate for the Machine Setups activity cost pool?

5. What is the activity rate for the Product Design activity cost pool?

6. What is the activity rate for the General Factory activity cost pool? (Round your answer to 2 decimal places.)

9. Using the ABC system, how much total manufacturing overhead cost would be assigned to Product Y? (Do not round intermediate calculations and round your final answer to the nearest dollar amount.)

10.

Using the ABC system, how much total manufacturing overhead cost would be assigned to Product Z? (Do not round intermediate calculations and round your final answer to the nearest dollar amount.)

11.

Using the plantwide overhead rate, what percentage of the total overhead cost is allocated to Product Y and Product Z? (Round your intermediate calculations to 2 decimal places. Round your "Percentage" answers to 2 decimal places. (i.e. 0.1234 should be entered as 12.34).)

12. Using the ABC system, what percentage of the Machining costs is assigned to Product Y and Product Z? (Round your intermediate calculations to 2 decimal places. Round your "Percentage" answers to 2 decimal places. (i.e. 0.1234 should be entered as 12.34).)

13. Using the ABC system, what percentage of Machine Setups cost is assigned to Product Y and Product Z? (Round your intermediate calculations to 2 decimal places. Round your "Percentage" answers to 2 decimal places. (i.e. 0.1234 should be entered as 12.34).)

14. Using the ABC system, what percentage of the Product Design cost is assigned to Product Y and Product Z? (Round your "Percentage" answers to 2 decimal places. (i.e. 0.1234 should be entered as 12.34)).

15. Using the ABC system, what percentage of the General Factory cost is assigned to Product Y and Product Z? (Round your intermediate calculations to 2 decimal places. Round your "Percentage" answers to 2 decimal places. (i.e. 0.1234 should be entered as 12.34).)

Special-Order Decision

Smooth Move Company manufactures professional paperweights and has been approached by a new customer with an offer to purchase 15,000 units at a per-unit price of $9.00. The new customer is geographically separated from Smooth Move's other customers, and existing sales will not be affected. Smooth Move normally produces 95,000 units but plans to produce and sell only 65,000 in the coming year. The normal sales price is $15 per unit. Unit cost information is as follows:

If Smooth Move accepts the order, no fixed manufacturing activities will be affected because there is sufficient excess capacity.

Required:

1. What are the alternatives for Smooth Move?
Accept or reject the special order

2. CONCEPTUAL CONNECTION: Should Smooth Move accept the special order?
Yes

By how much will profit increase or decrease if the order is accepted?
Increase  $

3. CONCEPTUAL CONNECTION: Briefly explain the significance of the statement in the exercise that “existing sales will not be affected” (by the special sale).

It indicates that there will be no product-line cannibalization; in other words, there is sufficient excess capacity such that the acceptance of the special sales will not decrease Smooth Move’s regular sales.