Johnson last month (December) sales were 20,000 units @ $50. The company estimates an increase of 1.5% in sales for January. An increase of 200 units forFebruary (compared to January) and a reduction of 100 units for March (compared to February. The selling price is not expected to change. April sales projectionsare a 5% Increase from December sales.INVENTORY POLICYFINISHED GOODS-maintain an ending inventory equal to 30% of next month salesDecember finished goods ending Inventory was 7,000 unitsDIRECT MATERIALS-maintain an ending inventory equal to 40% of next month productionApril production is estimated at 21,000Materials cost is $10 per pound. Each unit requires 25 pounds of materials and actual inventory is 1600 poundsLabor Cost is $14 per hour and each unit requires 30 minutes of labor.Fixed overhead is $62.517 monthly and variable overhead is 120% of direct labor cost.OTHER EXPENSESSelling salaries are $40,000 monthly, commissions on sales are 5% and administrative expenses are $70,000 monthlyCALCULATE PROJECTED RAW MATERIALS INVENTORY (FOR THE BALANCE SHEET)PRESENT YOUR ANSWER ROUNDED TO ZERO DECIMAL PLACESDON'T USE COMMA SEPARATORS

A budget is a forecast of revenue and expenses for a certain future period of time that is generally…

Johnson last month (December) sales were 20,000 units @ $50. The company estimates an increase of 1.5% in sales for January. An increase of 200 units for February (compared to January) and a reduction of 100 units for March (compared to February. The selling price is not expected to change. April sales projection are a 5% increase from December sales INVENTORY POLICY FINISHED GOODS-maintain an ending inventory equal to 30% of next month sales December finished goods ending inventory was 7,000 units DIRECT MATERIALS-maintain an ending inventory equal to 40% of next n next month production Aprill production is estimated at 21.000 Materials cost is $10 per pound. Each unit requires 25 pounds of materials and actual inventory is 1600 pounds Labor Cost is $14 per hour and each unit requires 30 minutes of labor. Fixed overhead is $62.517 monthly and variable overhead is 120% of direct labor cost. OTHER EXPENSES Selling salaries are $40,000 monthly, commissions on sales are 5% and administrative expenses are $70,000 monthly CALCULATE PROJECTED RAW MATERIALS INVENTORY (FOR THE BALANCE SHEET) PRESENT YOUR ANSWER ROUNDED TO ZERO DECIMAL PLACES DON'T USE COMMA SEPARATORS

Johnson last month (December) sales were 20,000 units @ $50. The company estimates an increase of 1.5% in sales for January. An increase of 200 units for February (compared to January) and a reduction of 100 units for March (compared to February. The selling price is not expected to change. April sales projection are a 5% increase from December sales INVENTORY POLICY FINISHED GOODS-maintain an ending inventory equal to 30% of next month sales December finished goods ending inventory was 7,000 units DIRECT MATERIALS-maintain an ending inventory equal to 40% of next n next month production Aprill production is estimated at 21.000 Materials cost is $10 per pound. Each unit requires 25 pounds of materials and actual inventory is 1600 pounds Labor Cost is $14 per hour and each unit requires 30 minutes of labor. Fixed overhead is $62.517 monthly and variable overhead is 120% of direct labor cost. OTHER EXPENSES Selling salaries are $40,000 monthly, commissions on sales are 5% and administrative expenses are $70,000 monthly CALCULATE PROJECTED RAW MATERIALS INVENTORY (FOR THE BALANCE SHEET) PRESENT YOUR ANSWER ROUNDED TO ZERO DECIMAL PLACES DON'T USE COMMA SEPARATORS

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 1R: Ranger Industries has provided the following information at June 30: Other information: Average...

See similar textbooks

Similar questions

Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?
Amusement tickets estimated sales are: What are the balances in accounts receivable for April, May, and June if 60% of sales are collected in the month of sale, 30% are collected the month after the sale, and 10% are collected the second month after the sale?
Fitbands estimated sales are: What are the balances in accounts receivable for January, February, and March if 65% of sales is collected in the month of sale, 25% is collected the month after the sale, and 10% is second month after the sale?
Cash collections for Wax On Candles found that 60% of sales were collected in the month of the sale, 30% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in January and February?
Murray electronics sales in May were 2,000 units @ $52 and 2,100 @ $54 in June. Sales projections are as follows: July an increase of 2% from June Sales (the sale price will be the same as June) August 2,200 units @$54 September an increase of 2% from August Sales (the sale price will be the same as August) INVENTORY POLICY Murray inventory policy is to maintain an ending inventory of 40% of next month sales. October Sales are expected to be 2,250 units. Actual inventory is 820 units. Each unit cost is $30. ACCOUNTS PAYABLE POLICY Murray pays 70% of merchandise purchases in cash and the remaining one month later. CALCULATE COST OF MERCHANDISE PURCHASES IN SEPTEMBER
Accounting Schrank Company is trying to decide how many units of merchandise to order eoch month. Compony policy is to have20%of the next month's sales in inventory ot the end of each manth. Projected soles for August, September, and October are 47,000 units. 32000 units, and 57,000 units, respoctively. How many units must be purchased in September?
The Volt Battery Company has forecast its sales in units as follows: January February March April May June July 1,000 850 800 1,300 1,550 1,700 1,400 Volt Battery always keeps an ending inventory equal to 120 percent of the next month's expected sales. The ending inventory for December (January's beginning inventory) is 1,200 units, which is consistent with this policy. Materials cost $11 per unit and are paid for in the month after purchase. Labor cost is $4 per unit and is paid in the month the cost is incurred. Overhead costs are $7,000 per month. Interest of $8,200 is scheduled to be paid in March, and employee bonuses of $13,400 will be paid in June. a. Prepare a monthly production schedule for January through June. Note: Input all amounts as positive values except Beginning Inventory values under Production Schedule which should be entered with a minus sign. Leave no cells blank be certain to enter O wherever required. Projected unit sales Desired ending inventory Total units…
SALES PROJECTIONS Wilson Sports basketball sales in August were 152,000 units. Sales are expected to grow by 1.5% in September. October sales are expected to be 1,000 units less than in September. November sales will be 19% more than October. The selling price of the basketballs will remain the same $30 per unit. December sales projection is 157.000 units. INVENTORY POLICIES FINISHED GOODS MAINTAIN AND ENDING INVENTORY EQUAL TO 25% OF NEXT MONTH SALES ACTUAL BEGINNING INVENTORY 38,500 UNITS DIRECT MATERIALS MAINTAIN AND ENDING INVENTORY EQUAL TO 30% OF NEXT MONTH PRODUCTION ACTUAL BEGINNING INVENTORY 9,000 POUNDS The cost of materials purchased in August were $210,000 REQUIREMENTS Each basketball requires 25 pounds of materials at a cost of $7 per pound. December production are projected to be 156,000 units Each basketball requires 15 minutes of labor at a rate of $12.00 per hour Fixed Overhead is $400,000 monthly and variable overhead is assigned as 130% of direct labor SELLING AND…
Truliant Co. sells a product called Withitall and has predicted the following sales for the first four months of the current year: January February March April Sales in units 17,000 1,900 2,100 1,600 Ending inventory for each month should be 20% of next month's sales. The number of units produced in February should be a.1,940 units b.1,900 units c.1,800 units d.1,850 units
IRWIN TECH sales in June were 400,000 units. Sales are expected to increase by 2% each month during the next 2 months (July and August) and an additional 8,000 units in September from August amount. Selling price is $16 per unit. Expected sales in October are 420,000 units. The firm inventory policy is to maintain an ending inventory equal to 25% of next month sales. Actual inventory is 103,000 units. Each unit requirements are as follows: .75 pounds of materials per unit 36 minutes of labor per hour variable overhead is allocated as 60% of labor Material cost is $6 per pound, labor cost is $10.50 per hour and fixed overhead is $105,000 monthly. Budgeted production units for October are 430,000 units and actual materials inventory is 95,000 pounds. Materials inventory policy is 30% of next month production. Calculate expected direct materials cost in July.
KCO, SRL anticipates the following sales in the given months: March 42,000 units April 59,000 units May 49,000 units June 55,000 units July 52,000 units Company policy is to maintain an ending finished goods inventory equal to 50% of the following month's sales. On the basis of this information, how many units would the company plan to produce in May?
Bookworm Corporation maintains ending inventory for each month at 5% of the following month's sales. It predicted the following sales (in units) for the first four months of the coming year: February 2,400 April 2,800 January March Sales (units) 2,000 3,000 How many units should be produced in March?