AC1320....Read Chapter 22, pp. 10501083. In the chapter, make sure to review "Decision Guidelines 22-1," p. 1081 and the following "Summary Problems"

the questions work sheet is attached to the document.

Thumbtack's March 31, 2012, budgeted balance sheet follows: THUMBTACK OFFICE SUPPLY Budgeted Balance Sheet March 31, 2012 Assets Current assets: Cash Accounts receivable Inventory Prepaid insurance Total current assets Plant assets: Equipment and fixtures Less: Accumulated depreciation Total plant assets Total assets Current liabilities: $18,000 12,000 16,000 2,200 $48,200 Liabilities Accounts payable Salary and commissions payable Total liabilities Stockholder's Equity Common stock 45,000 Retained earnings 30,000 Total stockholders' equity $15,000 $63,200 Total liabilities and stockholders' equity $12,500 1,400 $13,900 16,000 33,300 $49,300 $63,200 The budget committee of Thumbtack Office Supply has assembled the following data. a. Sales in April were $40,000. You forecast that monthly sales will increase 2% over April's sales in May. June's sales will increase 4% over April's sales. July's sales will increase 20% over April's sales. Collections are 80% in the month of sales and 20% in the month following sale. b. Thumbtack maintains inventory of $11,000 plus 2.5% of the COGS budgeted for the following month. COGS = 50% of sales revenue. Purchases are paid 30% in the month of purchase and 70% in the month following the purchase. c. Monthly salaries amount to $7,000. Sales commissions equal 5% of sales for that month. Salaries and commissions are paid 30% in the month incurred and 70% in the following month. d. Other monthly expenses are as follows: Rent expense Depreciation expense Insurance expense Income tax $2,400, paid as incurred $200 $100, expiration of prepaid amount 20% of operating income, paid as incurred Requirements: 1. Prepare Thumbtack's sales budget for April and May, 2012. Round all amounts to the nearest $1. 2. Prepare Thumbtack's inventory, purchases, and cost of goods sold budget for April and May. 3. Prepare Thumbtack's operating expenses budget for April and May. 4. Prepare Thumbtack's budgeted income statement for April and May. 5. Prepare the schedule of budgeted cash collections from customers for April and May. 6. Prepare the schedule of budgeted cash payments for purchases for April and May. 7. Prepare the schedule of budgeted cash payments for operating expenses for April and May. 8. Prepare the cash budget for April and May. Assume no financing took place. 9. Prepare a budgeted balance sheet as of May 31, 2012. 10. Prepare the budgeted statement of cash flows for the two months ended May 31, 2012. (Note: You should omit sections of the cash flows statements where the company h no activity.) Assume the following changes to the original facts: a. Collections of receivables are 60% in the month of sale, 38% in the month following the sale, and 2% are never collected. Assume the March receivables balance is net of the allowance for uncollectibles. b. Minimum required inventory levels are $8,000 plus 30% of next month's COGS. c. Purchases of inventory will be paid 20% in the month of purchase, 80% in the month following purchase. d. Salaries and commissions are paid 60% in the month incurred and 40% in the following month. Requirements: 1. Prepare Thumbtack's revised sales budget for April and May. Round all calculations to the nearest dollar. 2. Prepare Thumbtack's revised inventory, purchases, and cost of goods sold budget for April and May. 3. Prepare Thumbtack's revised operating expenses budget for April and May. 4. Prepare Thumbtack's revised budgeted income statement for April and May. ncrease onth of e mpany has t of the Refer to the original data and the revisions presented in Problem 1. Requirements: 1. Prepare the schedule of budgeted cash collections from customers for April and May. 2. Prepare the schedule of budgeted cash payments for purchases for April and May. 3. Prepare the schedule of budgeted cash payments for operating expenses for April and May. 4. Prepare the cash budget for April and May. Assume no financing took place. Jalapenos! is based in Pleasant Hill, California. The merchandising company has three divisions: Clothing, Food, and Spices. The Clothing division has two main product lines: T-shirts and sweatshirts. The company uses a shared warehousing facility. There are $50,000 in fixed warehousing costs each month, of which $40,000 are traceable to the three divisions based on the amount of square feet used. There is 100,000 square feet of warehouse space in the facility. The clothing division uses 60,000 square feet of the space, but 5,000 of that space isn't traceable to t-shirts or sweatshirts. Facts related to the divisions and products for the month ended October 31, 2012, follow: Square feet used Sales revenue COGS (variable) Fixed selling expenses Variable selling expenses Clothing Food T-shirts Sweatshirts 40,000 15,000 30,000 $300,000 $100,000 $150,000 $210,000 $60,000 $60,000 $7,000 $5,000 $3,000 $9,000 $8,500 $11,000 Spices 10,000 $80,000 $32,000 $1,000 $2,500 Requirements: 1. Calculate the rate per square foot for Warehousing. Calculate the traceable fixed costs for each division and for each product in the Clothing division. 2. Prepare an income statement for the company using the contribution margin approach. Calculate net income for the company, divisional segment margin for both divisions, and product segment margin for both products