Prepare a sales budget for July. Gourmet Grill Company Sales Budget For the Month Ending July 31 Product and Area Unit Sales Volume Unit Selling Price Total Sales Backyard Chef:         Maine fill in the blank 1 $fill in the blank 2 $fill in the blank 3   Vermont fill in the blank 4 fill in the blank 5 fill in the blank 6   New Hampshire fill in the blank 7 fill in the blank 8 fill in the blank 9   Total fill in the blank 10   $fill in the blank 11           Master Chef:         Maine fill in the blank 12 $fill in the blank 13 $fill in the blank 14   Vermont fill in the blank 15 fill in the blank 16 fill in the blank 17   New Hampshire fill in the blank 18 fill in the blank 19 fill in the blank 20   Total fill in the blank 21   $fill in the blank 22 Total revenue from sales     $fill in the blank 23 b. Prepare a production budget for July. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Gourmet Grill Company Production Budget For the Month Ending July 31   Units   Backyard Chef Master Chef Expected units to be sold  fill in the blank 25 fill in the blank 26 Desired inventory, July 31  fill in the blank 28 fill in the blank 29 Total units available  fill in the blank 31 fill in the blank 32 Estimated inventory, July 1  fill in the blank 34 fill in the blank 35 Total units to be produced  fill in the blank 37 fill in the blank 38 c. Prepare a direct materials purchases budget for July. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Gourmet Grill Company Direct Materials Purchases Budget For the Month Ending July 31   Grates (units) Stainless Steel (lbs.) Burner Sub- assemblies (units) Shelves (units) Total Required units for production:           Backyard Chef fill in the blank 39 fill in the blank 40 fill in the blank 41 fill in the blank 42   Master Chef fill in the blank 43 fill in the blank 44 fill in the blank 45 fill in the blank 46   Desired inventory, July 31 fill in the blank 47 fill in the blank 48 fill in the blank 49 fill in the blank 50   Total fill in the blank 51 fill in the blank 52 fill in the blank 53 fill in the blank 54   Estimated inventory, July 1 fill in the blank 55 fill in the blank 56 fill in the blank 57 fill in the blank 58   Total units to be purchased fill in the blank 59 fill in the blank 60 fill in the blank 61 fill in the blank 62   Unit price $fill in the blank 63 $fill in the blank 64 $fill in the blank 65 $fill in the blank 66   Total direct materials to be purchased $fill in the blank 67 $fill in the blank 68 $fill in the blank 69 $fill in the blank 70 $fill in the blank 71

Fuson Corporation makes one product and has provided the following information to help prepare the master budget for the next four months of operations: Budgeted selling price per unit $ 118 Budgeted unit sales (all on credit):     October   9,600 November   10,100 December   13,700 January   11,300 Raw materials requirement per unit of output   3 pounds Raw materials cost $ 4.00 per pound Direct labor requirement per unit of output   2.7 direct labor-hours Direct labor wage rate $ 23.00 per direct labor-hour Predetermined overhead rate (all variable) $ 12.00 per direct labor-hour   Credit sales are collected: 30% in the month of the sale 70% in the following month Raw materials purchases are paid: 30% in the month of purchase 70% in the following month The ending finished goods inventory should equal 10% of the following month's sales. The ending raw materials inventory should equal 10% of the following month’s raw materials production needs. The…

Required information [The following information applies to the questions displayed below.] Morganton Company makes one product and it provided the following information to help prepare the master budget: a. The budgeted selling price per unit is $65. Budgeted unit sales for June, July, August, and September are 9,000, 21,000, 23,000, and 24,000 units, respectively. All sales are on credit. b. Thirty percent of credit sales are collected in the month of the sale and 70% in the following month. c. The ending finished goods inventory equals 30% of the following month's unit sales. d. The ending raw materials inventory equals 20% of the following month's raw materials production needs. Each unit of finished goods requires 5 pounds of raw materials. The raw materials cost $2.70 per pound. e. Twenty percent of raw materials purchases are paid for in the month of purchase and 80% in the following month. f. The direct labor wage rate is $14 per hour. Each unit of finished goods requires two…

The budget director of Birds of a Feather Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January: Estimated sales for January:   Birdhouse 6,000 units at $55 per unit   Bird feeder 4,500 units at $75 per unit Estimated inventories at January 1: Direct materials:   Wood 220 ft.   Plastic 250 lb. Finished products:   Birdhouse 300 units at $23 per unit   Bird feeder 240 units at $34 per unit Desired inventories at January 31: Direct materials:   Wood 180 ft.   Plastic 210 lb. Finished products:   Birdhouse 340 units at $23 per unit   Bird feeder 200 units at $34 per unit Direct materials used in production: In manufacture of BirdHouse:   Wood 0.80 ft. per unit of product   Plastic 0.50 lb. per unit of product In manufacture of Bird Feeder:   Wood 1.20 ft. per unit of product   Plastic 0.75 lb. per…

Vaibhav Subject - Accounting

Bonkowski Corporation makes one product and has provided the following information to help prepare the master budget for the next four months of operations: Budgeted selling price per unit Budgeted unit sales (all on credit): January February March April Raw materials requirement per unit of output Raw materials cost Direct labor requirement per unit of output Direct labor wage rate Predetermined overhead rate (all variable) Variable selling and administrative expense Fixed selling and administrative expense Credit sales are collected: 30% in the month of the sale 70% in the following month Raw materials purchases are paid: 30% in the month of purchase 70% in the following month $ 97 10,000. 12,000 13,300 15,200 4 pounds $ 1.00 per pound 2.5 direct labor-hours $ 23.00 per direct labor- hour per direct labor- hour $9.00 $ 3.10 per unit sold. $70,000 per month. The ending finished goods inventory should equal 30% of the following month's sales. The ending raw materials inventory should…

Flexible Budget Performance Report AirQual Test Corporation provides on-site air quality testing services. The company has provided the following cost formulas and actual results for the month of February: The company uses the number of jobs as its measure of activity. For example, mobile lab operating expenses should be $2,900 plus $35 per job, and the actual mobile lab operating expenses for February were $4,530. The company expected to work 50 jobs in February, but actually worked 52 jobs. Required: Using Exhibit 9–8 as your guide, prepare a flexible budget performance report showing AirQual Test corporation’s revenue and spending variances and activity variances for February. Exhibit 9–8 Performance Report Combining Activity Variances with Revenue and Spending Variances

Hesterman Corporation makes one product and has provided the following information to help prepare the master budget for the next four months of operations: Budgeted selling price per unit $ 118 Budgeted unit sales (all on credit):     April   7,800 May   9,400 June   14,000 July   12,100 Raw materials requirement per unit of output   3 pounds Raw materials cost $ 3.00 per pound Direct labor requirement per unit of output   2.8 direct labor-hours Direct labor wage rate $ 25.00 per direct labor-hour Credit sales are collected: 40% in the month of the sale 60% in the following month   The ending finished goods inventory should equal 40% of the following month's sales. The ending raw materials inventory should equal 20% of the following month’s raw materials production needs.   If 39,720 pounds of raw materials are required for production in June, then the budgeted cost of raw material purchases for May is closest to:

Vinall Corporation makes one product and has provided the following information to help prepare the master budget for the next four months of operations: Budgeted selling price per unit $ 86 Budgeted unit sales (all on credit): July 9, 550 August 11, 800 September 10, 450 October 11,400 Raw materials requirement per unit of output 2.1 pounds Raw materials cost $ 2.1 per pound Direct labor requirement per unit of output 2.3 direct labor-hours Direct labor wage rate $ 25.5 per direct labor-hour Credit sales are collected: 30% in the month of the sale 70% in the following month Raw materials purchases are paid: 20% in the month of purchase 80% in the following month The ending finished goods inventory should equal 20% of the following month's sales. The ending raw materials inventory should equal 20% of the following month's raw materials production needs. PLEASE SHOW ALL EQUATIONS IN EXCEL FORMAT! Required: What are the budgeted sales for August? What are the expected cash collections…

I only need help with number 10 Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below. January 10,000 February 10,600 March 13,800 April 16,000 May 18,500 The following data pertain to production policies and manufacturing specifications followed by Ponderosa: Finished goods inventory on January 1 is 900 units. The desired ending inventory for each month is 20 percent of the next month’s sales. The data on materials used are as follows: Direct Material Per-Unit Usage Unit Cost Part #K298 2                $4         Part #C30 3                7         Inventory policy dictates that sufficient materials be on hand at the beginning of the month to satisfy 30 percent of the next month’s production needs. This is exactly the…