Complete the Sales Budget given the following Number of units sold will increase by 20% each month over the previous month. September October Totals $75 $75 $75 August Budgeted 500 Sales Units Selling Price $75 per unit Total $37,500 Budgeted Sales Complete the Production Budget given the above data and the following Starting in August the company decided the number of units in its finished goods inventory at each month-end should equal 80% of the next month's budgeted sales September October August Budgeted Sales 500 Units Next period budgeted sales units Desired ending inventory Total required units Beginning inventory units Units to produce Prepare a cash budget given the following data: Budgeted sales for April 25,000 units May 70,000 units June 50,000 units The selling price is $25 per unit. April May June Quarter Budgeted sales in units Selling price per unit Total budgeted sales All sales are on account 60% collected in the month of the sale 40% collected in the month following the sale In April, the 31 March accounts receivable balance of $45,000 will be collected in April Expected Cash Collection: Construct a cash collection schedule for April May June and a total for the Quarter. May June April 45,000 A/R 31 March April Sales Quarter 45,000 May Sales June Sales Totals Determine the spending variance using the following data. Shoo-Shu, Inc. uses the following direct material standard to manufacture king size mattresses 15 pounds per mattress at $13.50 per pound. Last weck, 8,000 pounds of material were purchased and used to make 550 mattresses. The total material cost was $111,360 Actual Quantity Actual Quantity X Actual Price X Standard Price Actual Quantity Standard Quantity Standard Price X Standard Price Spending variance = Determine the spending variance using the following data: Shoo-Shu, Inc. uses the following direct labor standard for its mattresses: 3.75 standard hours per mattress at $22.50 per hour. Last month, employees actually worked 2,100 hours for a total labor cost of $46,415 to make 550 mattresses. Actual Quantity Actual Quantity Actual Rate X Standard Rate Actual Quantity Standard Quantity Standard Price X Standard Price Spending variance = Computer the variable MOH rate and efficiency variances given the following information: Top Shoe Mfg. uses direct labor hours as the allocation base in its predetermined OH rate. The company has the following standard variable MOH cost for each left- handed shoe 3.7 standard labor hours per left-handed shoe at $9.25 per labor hour. Last month, employees actually worked 19,000 labor hours to make 5,000 left handed shoes. (Round off your answers to 2 decimal places). Variable MOH was actually $170,000 Actual Hours X Actual Rate Actual Hours Standard Rate Actual Hours Standard Rate Standard Hours Standard Rate Calculate the ROI for Yr. 2 given the following data: Calculate your answer to five decimal points Income Operating Assets Sales Yr. 1 $13,500 $109,009 $122,093 Yr. 2 $19,332 $134,231 $155 301 Calculate the Turnover for Yr. 2 given the following data: Calculate your answer to five decimal points. Income Operating Assets Sales Yr. 1 $13,500 $109.009 $122.093 Yr. 2 $19,332 $134,231 $155,301 Calculate the Profit Margin for Yr. 2 given the following data: Calculate your answer to five decimal points. Income Yr. 1 $13,500 Yr. 2 $19,332 Operating Assets Sales $109,009 $122.093 $134,231 $155 301 Calculate ROI if Sales = $105,000, Operating Expenses = $87,000 and Investment Turnover = 2.11 Big Money, Inc. has four departments. The cafeteria serves each of them. The cafeteria cost is allocated to each of the departments based on the number of employees in each department. Total cafeteria cost per month is $17,500. The four departments and the number of employees in each is: Collections 120 employees Soliciting 200 employees Admin 50 employees Legal 30 employees Total 400 employees Given the following data, calculate the number of days in the Cash Conversion Cycle for Top Dogg Industries Accounts Receivable = $1,300,000 Inventory = $1,500,000 Sales = $15,000,000 Cost of Goods Sold = $13,000,000 Accounts Payable = $2,700,000