Problem no1: Presented below is a balance sheet for Ken Carr Lawn Service at December 31, 2005. KEN CARR LAWN SERVICE Balance Sheet December 31, 2005 Assets Liabilities and Owner's Equity Cash $13,000 Liabilities Accounts receivable 6,000 Accounts payable $ 8,000 Supplies 9,000 Notes payable 15,000 Equipment 11,000 Owner's equity Ken Carr, Capital 16,000 Total assets $39,000 Total liabilities & owner's equity $39,000 The following additional data are available for the year which began on January 1: All expenses (excluding supplies expense) total $6,000. Supplies on January 1, were $11,000 and $3,000 of supplies were purchased during the year. Net income for the year was $8,000 and drawings were $5,000. Instructions: Determine the following: (Show all computations.) 1. Supplies used during the year. 2. Total expenses for the year. 3. Service revenues for the year. 4. Ken Carr's capital balance on January 1 Answer:

Problem 12-19 Dropping or Retaining a Segment [LO12-2]

Jackson County Senior Services is a nonprofit organization devoted to providing essential services to seniors who live in their own homes within the Jackson County area. Three services are provided for seniors—home nursing, Meals On Wheels, and housekeeping. Data on revenue and expenses for the past year follow: Total Home Nursing Meals On Wheels House-
keeping Revenues $ 933,000 $ 266,000 $ 407,000 $ 260,000 Variable expenses 471,000 114,000 199,000 158,000 Contribution margin 462,000 152,000 208,000 102,000 Fixed expenses: Depreciation 69,600 8,500 40,400 20,700 Liability insurance 43,800 20,600 7,300 15,900 Program administrators’ salaries 114,300 40,900 38,200 35,200 General administrative overhead* 186,600 53,200 81,400 52,000 Total fixed expenses 414,300 123,200 167,300 123,800 Net operating income (loss) $ 47,700 $ 28,800 $ 40,700 $ (21,800)

*Allocated on the basis of program revenues.

The head administrator of Jackson County Senior Services, Judith Miyama, considers last year’s net operating income of $47,700 to be unsatisfactory; therefore, she is considering the possibility of discontinuing the housekeeping program.

The depreciation in housekeeping is for a small van that is used to carry the housekeepers and their equipment from job to job. If the program were discontinued, the van would be donated to a charitable organization. None of the general administrative overhead would be avoided if the housekeeping program were dropped, but the liability insurance and the salary of the program administrator would be avoided.

Required:

1. What is the financial advantage (disadvantage) of discontinuing the Housekeeping program?

2. Prepare a properly formatted segmented income statement.

Helicopter Gear is planning to expand its product line, which requires investment of $470,400 in special-purpose machinery. The machinery has a useful life of six years and no salvage value. The estimated annual results of offering the new products are as follows:

Revenue: $524,000

Expenses (including straight-line depreciation): (498,400)

Increase in net income: $25,600

All revenue from the new products and all expenses (except depreciation) will be received or paid in cash in the same period as recognized for accounting purposes.

The return on average investment for this proposed investment is closest to:

a. 5.44%

b. 10.88%

c. 4.89%

d. 44.22%

Data Scenario:You have just been hired into a management position which requires the application of your budgeting skills.You find out that budgeting has not been a priority of the company and that they have been experiencing cash shortages.You have contacted various areas on the organization and have accumulated the information below to assist youin preparing a comprehensive budget.Following is actual information relates to the operations of a merchandiser named Sled Company, a wholesaler of sleds as of March 31.Cash$7,000Accounts receivable15,200Inventory22,960Accounts Payable22,000Actual and Budgeted sales dollar Data-Sales Budget:March (actual)$38,000April$41,000May$42,000June$40,000July$43,000Sales are following type:65% Cash sales collected in month of sale35% Credit sales collected in the following month of saleCredit sales are collected in the month following sale. The accounts receivable at March 31 are a result of March credit sales.Cost of goods sold equals80% of sales priceAt the end of each month, inventory is to be on hand equal to70% of following month’s sales needs, stated at cost.Inventory purchases are paid47% in month of purchase53% in month after purchaseThe accounts payable at March 31 are a result of March purchases of inventory.Monthly expenses are as follows and are paid in the month incurred if it is a cash expense.Salaries and wages13% of sales dollarRent$2,500 per monthOther cash expenses4% of sales dollarAdvertising$1,000 per monthDepreciation$900 for April onlyDepreciation$1,000 per the months of May and JuneEquipment purchased for cashin May$2,000Required:See page 3621. Prepare a Cash Receipts Budget for the quarter ending June 30th, by month and quarter.You do not need a formal sales budget since the sales budget is above in the data.2. Prepare a merchandise purchase budget by month and quarter. A merchandiser purchases in dollars.I have set up a formatted budget for you. You can see how I have made a few minor changes to Schedule 2 on page 356, which is a production budget which we are not preparing.Make sure you think about the numbers you use in the quarter column.I am specifically talking about how you handle beginning and ending inventory.3. Prepare a Selling and Administrative Expense Budget, by month and quarter.See page 361***My budget is a little bit different than the one in the text, because I used percentage of sales dollar.4. Prepare a Cash Disbursements Budget, by month and quarter.See page 363***5. Prepare a cash budget showing the months and quarter.Use the format I have provided on the budget sheet.Do not worry about a minimum cash balance or financing needs, since we are trying to develop a cash management plan.6. Based on the quarterly cash budget you prepared, do you have any recommendationson cash management. Discuss the type of business and the cash flow problems a company in this industry might have.Type your answer on the budget worksheet , where I have set out the question.7. Prepare a budgeted income statement for the quarter ending June 30, 20XX.You do not need to show monthly columns.I entered Sales for you on the income statement8. What do you think about the survivability of this business?9. What if the company finds out the monthly rent will increase to $2,800, what budgets are effected? Why?What is the New Net income(Loss)?If you have linked everything correctly, you should only have to change the monthly renton this sheet to determine your answer to the questions asked. Please change the rent back to the original amount of 2,500 before you submit.For each error withinbudget2 pts. for each budget1 pt.1 pt.1 pt.#1Sled CompanyCash collections for the quarter ending June 30, 20XXAprilSales Revenue(Given)Cash sales collected in month saleCredit sales Collected in following monthTotal Cash receiptsMayJuneQuarter$41,000$26,65015,200$41,85065%35%#2Sled CompanyMerchandise purchase budgetFor the quarter ended June 30, 20XXAprilMayJuneQuarterSled CompanySelling and administrative Expenses BudgetFor the quarter ended June 30,20XXAprilMayJuneQuarterBudget Cost of goods soldDesired Ending inventoryTotal needsLess: Beginning InventoryTotal purchase cost#3SalesVariable selling and admin. expense %Total variable cash expensesFixed Selling and admin. expenses:RentAdvertisingDepreciationTotal fixed expensesTotal selling and administrative expenses17%#4Sled CompanyCash Disbursements BudgetFor the quarter ended June 30,20XXAprilCost of Merchandise Purchases(from Schedule 2)Cash payments for purchases paid in monthCash payments made in month after purchaseTotal Cash payments for merchandise purchasedOther cash disbursementsMayJuneQuarter47%53%Total of other cash disbursementsTotal cash Disbursements#5Sled CompanyCash BudgetFor the quarter ended June 30, 20XXAprilMayJuneQuarterBeginning cashAdd: Cash ReceiptsCash AvailableLess Cash Disbursements:Ending cash6. Based on the quarterly cash budget you prepared, do you have any recommendationson cash management. Discuss the type of business and the cash flow problems a company in this industry might have.#7Sled CompanyBudgeted Income StatementFor the quarter ended June 30, 20XXSalesCost of goods soldGross marginLess selling and administrative ExpensesOperating income123,0008. What do you think about the survivability of this business?9. What if the company finds out the monthly rent will increase to $2,800, what budgets are effected? Why?What is the New Net income(Loss)?If you have linked everything correctly, you should only have to change the monthly renton this sheet to determine your answer to the questions asked. Please change the rent back to the original amount of 2,500 before you submit.

Purity, Inc., bottles and distributes mineral water from the company’s natural springs innorthern Oregon. Purity markets two products: twelve-ounce disposable plastic bottles and four-gallon reusable plastic containers.