Connect EXERCISE 9–1 Prepare a Flexible Budget LO9-1 aset Sound Divers is a company that provides diving services such as underwater ship repairs to Mc Graw Hill ducation nts in the Puget Sound area. The company's planning budget for May appears below: Puget Sound Divers Planning Budget For the Month Ended May 31 Budgeted diving-hours (q) 100 Revenue ($365.00q) .... $36,500 Expenses: Wages and salaries ($8,000 + $125.00q) Supplies ($3.00q) ..... Equipment rental ($1,800 + $32.00q) ..... Insurance ($3,400) Miscellaneous ($630 + $1.80q) .... 20,500 300 5,000 3,400 810 30,010 Total expense $ 6,490 Net operating income ... During May, the company's actual activity was 105 diving-hours. Required: Using Exhibit 9–5 as your guide, prepare a flexible budget for May.
Q: Exercise 9-1 (Algo) Prepare a Flexible Budget [LO9-1] Puget Sound Divers is a company that provides…
A: Flexible Budget is that budget which changes with changes in level of activity.
Q: Exercise 9-4 Direct Labor Budget [LO9-5] The production manager of Rordan Corporation has…
A: Direct labor budget is used to calculate how many hours of work is needed and how much labor cost…
Q: Exercise 8-5 (Algo) Manufacturing Overhead Budget [LO8-6] The direct labor budget of Yuvwell…
A:
Q: Exercise 9-1 (Algo) Prepare a Flexible Budget [LO9-1) Puget Sound Divers is a company that provides…
A: Puget Sound Diver ++: Flexible Budget for the month ended may 31st Particulars Amount Revenue…
Q: Problem 6 (Flexible Budget) Factory Overhead Flexible Budget Preparation Summary flexible overhead…
A: Flexible budgets are those estimates or forecasts that is made for future period of time and these…
Q: Stevenson Inc. budgeted production of 45,000 personal journals in 20Y6. Each journal requires…
A: Direct Labor budget is prepared to ascertain in advance the total labor cost for the period.
Q: Exercise 6-17 Reliance, Inc. utilizes a standard cost system for budget and control purposes.…
A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
Q: Problem 14-20A (Static) Preparing a cash budget LO 14-5 Fayette Medical Clinic has budgeted the…
A: The cash budget is prepared to record cash receipts and cash payments during the period and further…
Q: Down Under Products, Ltd., of Australia has budgeted sales of its popular boomerang for the next…
A: Sales units Closing inventory = 20% of the following month requirement Production units = Sales…
Q: Exercise 8-8 (Algo) Budgeted Income Statement [LO8-9] Gig Harbor Boating is the wholesale…
A: The budgeted income statement is prepared to know the estimated revenue, expenditure, and also the…
Q: Brighton, Inc., manufactures kitchen tiles. The company recently expanded, and the controller…
A: Production Budget Format:- Budgeted sales Inventory required at end of month…
Q: Exercise 9-4 (Algo) Prepare a Flexible Budget Performance Report [LO9-4] Vulcan Flyovers offers…
A: The flexible budget performance report analyzes the actual results, flexible budget data and…
Q: EXERCISE 9-13 Direct Materials and Direct Labor Budgets [L04, LO5] The production department of…
A: The direct materials budget estimates the needed materials to be purchased by time order in order to…
Q: Exercise 8-2 Production Budget [LO8-3] Down Under Products, Ltd., of Australia has budgeted sales of…
A: 1. ENDING FINISHED INVENTORY : 20% OF THE FOLLOWING MONTH FOR APRIL = 85,000 (MAY INVENTORY) X 20%…
Q: 9-4
A: Prepare a flexible budget performance report for July. Working note: Calculate the variable cost…
Q: Problem 9-39 Sales, Production, and Purchases Budgets; Activity-Based Overhead Budget (LO 9-3, 9-4,…
A: This budget is mainly used for the planning of material purchases in order to fulfill the budgeted…
Q: EXERCISE 9-12 Sales and Production Budgets [LO2, LO3] The marketing department of Jessi Corporation…
A: Budgeting: It is a process of planning the work to be performed. Under this process a formal plan is…
Q: Exercise 6 (Selling and Administrative Budget) The budgeted unit sales of Helene Company for the…
A: To create the selling and administrative budget, we will first have to determine the total variable…
Q: Exercise 8-7 Cash Budget [LO8-8] Garden Depot is a retailer that is preparing its budget for the…
A: Cash Budget :— It is the budget made by company to estimate the flow of cash & cash equivalents…
Q: EXERCISE 9-11 Production and Direct Materials Budgets [LO3, LO4] The marketing department of Gaeber…
A: The budget or plan of how many units to produce by noticing the requirements of the company is…
Q: Exercise 23.1 (Algo) Budgeting Purchases and Cash Payments (LO23-4, LO23-5) The following…
A: The question is based on the concept of Cost Accounting.
Q: PR 7-4A Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly…
A: A Cash Budget represents the cash receipts and cash payments for the period. It helps the company to…
Q: EXERCISE 9-12 Sales and Production Budgets [L02, LO3] The marketing department of Jessi Corporation…
A: The estimation in which the number of units of sales budgeted is multiplied to its price to arrive…
Q: Exercise 3 (Materials Purchase Budget) Mini Products, Inc., has developed a very powerful electronic…
A: The company will prepare budget to have a goal to achieve at the end of the specified period. The…
Q: EXERCISE 95 Manufacturing Overhead Budget [LO6] The direct labor budget of Yuvwell Corporation for…
A: Manufacturing overhead: Manufacturing overhead can be defined as the cost that is incurred in the…
Q: Direct Materials and Direct Labor Budgets [LO4, LO5] The production department of Zan Corporation…
A: Zan Corporation Direct Materials Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year…
Q: Sheridan Entertainment Corporation prepared a master budget for the month of November that was based…
A: With formulae:
Q: Nina Company prepared the following fixed budget for July using 7,640 units for budgeted sales.…
A: Variances shows the difference or variation between the budgeted and the actual amounts. If the…
Q: The following data relate to the operations of Shilow Company, a wholesale distributor of consumer…
A: Since you have asked multiple questions we will solve the first 3 sub-question for you,If you want…
Q: Exercise 9-1 (Algo) Prepare a Flexible Budget [LO9-1] Puget Sound Divers is a company that provides…
A: Flexible budget or variable budget is a financial plan of estimated revenue and expenditure which…
Q: EXERCISE 9-13 Direct Materials and Direct Labor Budgets [LO4, LO5] The production department of…
A: Given Information : Direct Labor Hour = 0.60 of Units Labor cost = $14 per hour Ending Inventory…
Q: Exercise 20-5 (Algo) Manufacturing: Production budget LO P1 Tyler Company budgets the following unit…
A: Production budget is prepare to estimate the units to be produce for expected sales. It can be…
Q: xercise 8-4 (Algo) Direct Labor Budget [LO8-5] The production manager of Rordan Corporation has…
A: A direct labour budget is prepared by a company to determine the total direct labour hours required…
Q: EXERCISE 9-9 Planning Budget LO9-1 Lavage Rapide is a Canadian company that owns and operates a…
A: A planning budget refers to the statement prepared by the management based on the estimations to…
Q: EXERCISE 9-6 Selling and Administrative Expense Budget [LO7] The budgeted unit sales of Weller…
A: The Numerical has covered the concept of Budgeting. A Business Budget is a plan covering all phases…
Q: Exercise 9-21 Missing Amounts; Various Types of Budgets (LO 9-3, 9-5, 9-6) Fill in the missing…
A: The statement of retained earnings is prepared to record changes in retained earnings such as net…
Q: Schedule of expected cash collections: 2-a. Merchandise purchases budget: 2-b. Schedule of…
A: Budget is an estimation of revenue and expenses over a period of time and usually compiled and…
Q: Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third…
A: Budget is very important aspect of accounting.Budgeting decides on how to plan on expenditure.In…
Q: Activity No. 12 Master Budget Computation Furniture Manufacturing Company - School Desk Division…
A: Budgeting is an Estimation of Expected Expenses or a particular production to be need in Future.…
Q: Exercise 9-3 (Algo) Revenue and Spending Varlances [(LO9-3] Quilcene Oysterla farms and sells…
A: The variance is the difference between the actual data and standard output of the production.
Q: EXERCISE 9-3 Direct Materials Budget [LO4] Three grams of musk oil are required for each bottle of…
A:
Q: Problem 8-30 (Algo) Integration of the Sales, Production, and Direct Materials Budgets [LO8-2,…
A: Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third…
Q: PROBLEM 9-18 Direct Materials and Direct Labor Budgets [LO4, LO5] The production department of Zan…
A: Answer 1: Below is the image with the formula for the above solution:
Q: Exercise 10-4 Prepare a Flexible Budget Performance Report [LO10-4] Vulcan Flyovers offers scenic…
A: Revenue and spending variance = Actual results - Flexible budget Activity variance = Planning budget…
Q: Problem 8-30 (Static) Integration of the Sales, Production, and Direct Materials Budgets [LO8-2,…
A: “Since you have asked multiple sub-parts, we will solve the first three sub-parts for you. If you…
Q: Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has…
A: Opening cash balance a Total cash receipts b Total cash disbursements c Closing cash…
Q: Problem 13-61 (Algo) Comprehensive Budget Plan (LO 13-4, 5, 6) Brighton, Inc., manufactures kitchen…
A: Budgeting: It is a process of planning the work to be performed. Under this process a formal plan is…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
- Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January I, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared by the Accounting Department of Regina Soap Co.: Cash 85,000 Accounts Receivable........................................ 125,600 Finished Goods............................................ 69,300 Work in Process............................................ 32,500 Materials.................................................. 48,900 Prepaid Expenses.......................................... 2,600 Plant and Equipment....................................... 325,000 Accumulated DepreciationPlant and Equipment........... 156,200 Accounts Payable.......................................... 62,000 Common Stock. 10 par.................................... 180,000 Retained Earnings.......................................... 290,700 688,900 688,900 Factory output and sales for 20Y9 are expected to total 200,000 units of product, which are to be sold at 5.00 per unit. The quantities and costs of the inventories at December 31, 20Y9, are expected to remain unchanged from the balances at the beginning of the year. Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows: Estimated Costs and Expenses Fixed Variable (Total for Year) (Per Unit Sold) Cost of goods manufactured and sold: Direct materials.................................. 1.10 Direct labor...................................... 0.65 Factory overhead: Depreciation of plant and equipment........... 40,000 Other factory overhead........................ 12,000 0.40 Selling expenses: Sales salaries and commissions.................... 46,000 0.45 Advertising...................................... 64,000 Miscellaneous selling expense................... 6,000 0 25 Administrative expenses: Office and officers salaries........................ 72,400 0.12 Supplies......................................... 5,000 0.10 Miscellaneous administrative expense............. 4,000 0.05 Balances of accounts receivable, prepaid expenses, anti accounts payable at the end of the year are not expected to differ significantly from the beginning balances. Federal income tax of 30,000 on 20Y9 taxable income will be paid during 20Y9. Regular quarterly cash dividends of 0.15 per share are expected to be declared and paid in March, June. September, and December on 18,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for 75,000 cash in May. Instructions 1. Prepare a budgeted income statement for 20Y9. 2. Prepare a budgeted balance sheet as of December 31, 20Y9, with supporting calculations.Forecast sates volume and sales budget For 20Y8, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y8, the following unit sales data were reported for the year: Unit Sales 8" 10" Frame 12" 16" Frame East 8,755 3,686 Central 6,510 3,090 West 12,348 5,616 For the year ending December 31, 20Y9, unit sales are expected to Follow the patterns established during the year ending December 31, 20Y8. The unit selling price for the 8" 10" the frame is expected to Increase to 17 and the unit selling price for the 12" 16" frame is expected to increase to 32, effective January 1, 20Y9. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31,. 20Y8, Over budget. Place your answers in a columnar table with the following format: 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y9, compute the unit sales volume to lie used for preparing the sales budget for the year ending December 31, 20Y9. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest. 20Y8 Percentage 20Y9 Actual Increase Budgeted Units (Decrease) Units (rounded) 3. Prepare a sales budget for the year ending December 51. 20Y9.Budgeted income statement and supporting budgets The budget director of Feathered Friends Inc., with the assistance of thee controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for December: A. Estimated sales for December Bird house....................... 3,200 units at 50 per unit Bird feeder....................... 3,000 units at 70 per unit B. Estimated inventories at December 1: Direct materials Finished products: Wood............ 220 ft Bird house........ 320 units at 27 per unit Plastic............ 240 ft Bird house........ 270 units at 40 per unit C. Desired inventories at December 31: Direct materials Finished products: Wood............ 220 ft Bird house........ 290 units at 27 per unit Plastic............ 200 ft Bird house........ 205 units at 41 per unit D. Direct materials used in production: In manufacture of Bird House: In manufacture of Bird Feeder: Wood............ 0.80 ft. per unit of product Wood........ 1.20 ft. per unit of product Plastic............ 0.50 lb. per unit of product Plastic......... 0.75 lb. per unit of product E. Anticipated cost of purchases and beginning and ending inventory of direct materials: Wood 7.00 per ft Plastic 1.00 per lb. F. Direct labor requirements: Bird House: Fabrication Department...................... 0.20 hr. at 16 per hr. Assembly Department........................ 0.30 hr. at 12 per hr. Bird Feeder: Fabrication Department...................... 0.40 hr. at 16 per hr. Assembly Department........................ 0.35 hr. at 12 pr hr. G. Estimated factory overhead costs for December: Indirect factory wages 75,000 Depreciation of plant and equipment 23,000 Power and light 6,000 Insurance and property tax 5,000 H. Estimated operating expenses for December: Sales salaries expense 70,000 Advertising expense 18,000 Office salaries expense 21,000 Depreciation expenseoffice equipment 600 Telephone expenseselling 550 Telephone expenseadministrative 250 Travel expenseselling 4,000 Office supplies expense 200 Miscellaneous administrative expense 400 I. Estimated other income and expense for December: Interest revenue200 Interest expense122 J. Estimated tax rate: 30% Instructions 1. Prepare a sales budget for December. 2. Prepare a production budget for December. 3. Prepare a direct materials purchases budget for December. 4. Prepare a direct labor cost budget for December. 5. Prepare a factory overhead cost budget for December. 6. Prepare a cost of goods sold budget for December. Work in process at the beginning of December is estimated to be 29,000, and work in process at the end of December is estimated to be 35,400. 7. Prepare a selling and administrative expenses budget for December. 8. Prepare a budgeted income statement for December.
- Forecast sales volume and sales budget Sentinel systems Inc. prepared the following sales budget for 20Y8: At the end of December 20Y8, the following unit sales data were reported for the year: Unit Sales Home Alert System Business Alert System United States 1,734 1,078 Europe 609 329 Asia 432 252 For the year ending December 31, 20Y9, unit sales are expected to follow the patterns established during the year ending October 31, 20Y8. The unit selling price for the Home: Alert System is expected to increase to 250, and the unit selling price for the Business Alert System is expected to be increased 820, effective January 1, 20Y9. Instructions 1. Compute the increase or decrease.ase of actual unit sales for the year ended October 31, 20Y8, over budget. Place your answers in a columnar table with the following format: 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y9, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 20Y9. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest unit. 20Y8 Percentage 20Y9 Actual Increase Budgeted Units (Decrease) Units (rounded) 3. Prepare a sales budget for the year ending December 31, 201Y9Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared by the Accounting Department of Mesa Publishing Co.: Cash. 26,000 Finished Goods.............................................. 16,900 Work in Process.............................................. 4,200 Materials.................................................... 6,400 Prepaid Expenses............................................ 600 Plant and Equipment......................................... 82,000 Accumulated DepreciationPlant and Equipment............. 32,000 Accounts Payable............................................ 14,800 Common Stock. 1.50 par..................................... 30,000 Retained Earnings............................................ 83,100 159,900 159,900 Factory output and sales for 20Y9 are expected to total 3,800 units of product, which are to be sold at 120 per unit. The quantities and costs of the inventories at December 31, 20Y9, are expected to remain unchanged from the balances at the beginning of the year. Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows: Estimated Costs and Expenses Fixed Variable (Total for Year) (Per Unit Sold) Cost of goods manufactured and sold: Direct materials................................... 30.00 Direct labor....................................... 840 Factory overhead: Depreciation of plant and equipment............ 4,000 Other factory overhead......................... 1,400 4.80 Selling expenses: Sales salaries and commissions..................... 12,800 13.50 Advertising....................................... 13,200 Miscellaneous selling expense..................... 1,000 2.50 Administrative expenses: Office and officers salaries......................... 7,800 7.00 Supplies.......................................... 500 1.20 Miscellaneous administrative expense.............. 400 2.40 Balances of accounts receivable, prepaid expenses, and accounts payable at the end of the year are not expected to differ significantly from the beginning balances, federal income tax of 35,000 on 20Y9 taxable income will be paid during 20Y9. Regular quarterly cash dividends of 0.20 per share are expected to be declared and paid in March, June, September, and December on 20,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for 22,000 cash in May. Instructions 1. Prepare a budgeted income statement for 20Y9. 2. Prepare a budgeted balance sheet as of December 31, 20Y9, with supporting calculations.Budgeted income statement and supporting budgets The budget director of Gold Medal Athletic Co., 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 March: A. Estimated sales for March: Batting helmet.................. 1,200 units at 40 per unit Football helmet................. 6,500 units at 160 per unit B. Estimated inventories at March 1: Direct materials: Finished products: Plastic............ 90 lbs. Batting helmet....... 40 units at 25 per unit Foam lining....... 80 lbs. Football helmet...... 240 units at 77 per unit C. Desired inventories at March 31: Direct materials: Finished products: Plastic............ 50 lbs. Batting helmet....... 50 units at 25 per unit Foam lining....... 65 lbs. Football helmet...... 220 units at 78 per unit D. Direct materials used in production: In manufacture of batting helmet: Plastic............................... 1.2lbs. per unit of product Foam lining......................... 0.5 lb. per unit of product In manufacture of football helmet: Plastic............................... 3.5lbs. per unit of product Foam lining.......................... 1.5 lbs. per unit of product E. Anticipated cost of purchases and beginning and ending inventory of direct materials: Plastic........................ 6 per lb. Foam lining................... 4 per lb. F. Direct labor requirements Batting helmet: Molding Department............. 0.2 hr. at 20 per unit Assembly Department............ 0.5 hr. at 14 per hr. Football helmet: Molding Department............. 0.5 hr. at 20 per hr. Assembly Department............ 1.8 hrs. at 14 per hr. G. Estimated factory overhead costs for March: Indirect factory wages 86,000 Depreciation of plant and equipment 12,000 Power and light 4,000 Insurance and property tax 2,300 H. Estimated operating expenses for March: Sales salaries expense 184,300 Advertising expense 87,300 Office salaries expense 32,400 Depreciation expenseoffice equipment 3,800 Telephone expenseselling 5,800 Telephone expenseadministrative 1,200 Travel expenseselling 9,000 Office supplies expense 1,100 Miscellaneous administrative expense 1,000 I. Estimated other income and expense for March: Interest revenue 940 Interest expense 872 J. Estimated tax rate:30% Instructions 1. Prepare a sales budget for March. 2. Prepare a production budget for March. 3. Prepare a direct materials purchases budget for March. 4. Prepare a direct labor cost budget for March. 5. Prepare a factory overhead cost budget for March. 6. Prepare a cost of goods sold budget for March. Work in process at the beginning of March is estimated to be 15,300, and work in process at the end of March is desired to be 14,800. 7. Prepare a selling and administrative expenses budget for March. 8. Prepare a budgeted income statement for March.
- Professional labor cost budget for a service company Based on the data in Exercise 227 and assuming that the average compensation per hour for staff is 45 and for partners is 140, prepare a professional labor cost budget for each department for Rollins and Cohen, CPAs, for the year ending December 31, 20Y7. Use the following column headings: Staff PartnersBudgeted income statement and supporting budgets 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: a. Estimated sales for January: Birdhouse 6.000 units at 55 per unit Bird feeder 4,500 units at 75 per unit b. Estimated inventories at January 1: Direct materials: Finished products: Wood 220 ft. Birdhouse 300 units at 23 per unit Plastic 250 lb. Bird feeder 240 units at 34 per unit c. Desired inventories at January 31: Direct materials: Finished products: Wood 180 ft. Birdhouse 340 units at 23 per unit Plastic 210 lb. Bird feeder 200 units at 34 per unit d. Direct materials used in production: In manufacture of Birdhouse: In manufacture of Bird Feeder: Wood ... 0.80 ft. per unit of product Wood 1.20 ft. per unitof product Plastic . . 0.50 lb. per unit of product Plastic 0.75 lb. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Wood 8.00 per ft. Plastic 1.20 per lb. f. f. Direct labor requirements: Birdhouse: Fabrication Department 0.20 hr. at15 per hr. Assembly Department 0.30 hr. at 12 per hr. Bird Feeder: Fabrication Department 0.40 hr. at15 per hr. Assembly Department 0.35 hr. at 12 per hr. g. Estimated factory overhead costs for January: Indirect factory wages 80,000 Power and light 8,000 Depreciation of plant and equipment 25,000 Insurance and property tax 2,000 h. Estimated operating expenses for January: Sales salaries expense 90,000 Advertising expense 20,000 Office salaries expense 18,000 Depredation expenseoffice equipment 800 Telephone expenseselling 500 Telephone expenseadministrative 200 Travel expenseselling 5,000 Office supplies expense 250 Miscellaneous administrative expense 450 i. Estimated other income and expense for January: Interest revenue 300 Interest expense 224 j. Estimated tax rate: 30% Instructions 1. Prepare a sales budget for January. 2. Prepare a production budget for January. 3. Prepare a direct materials purchases budget for January. 4. Prepare a direct labor cost budget for January. 5. Prepare a factory overhead cost budget for January. 6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be 29,000, and work in process at the end of January is estimated to be 35,400. 7. Prepare a selling and administrative expenses budget for January. 8. Prepare a budgeted income statement for January.