Exercise 9-1 (Algo) Prepare a Flexible Budget [LO9-1]Puget Sound Divers provides diving services, such as underwater ship repairs, to its clients. The company's planning budget for Mayappears below:Puget Sound DiversPlanning Budgetfor the month ended may 31Budgeted diving-hours (4)Revenue ($410.000)Mages and salaries ($11,000+ $128.000)Supplies ($3.000)equipment rental ($2,100 $24.000)Insurance ($4,000)Miscellaneous ($330 + $1.484)Total expensesnet operating InconePuget Sound DiversFlexible BudgetFor the Month Ended May 31Actual diving-hoursRevenueExpenses:During May, the company's actual activity was 340 diving-hours.Required:Prepare a flexible budget for MayNote: Round your answers to the nearest whole number.Wages and salariesSuppliesEquipment rentalInsuranceMiscellaneousTotal expensesNet operating Income$ 143,50051,75010,9004,0000073,498$ 70,002

Flexible Budget : A flexible Budget helps to adjust the budgeted amount based on the actual sales.…

Exercise 9-1 (Algo) Prepare a Flexible Budget [LO9-1] Puget Sound Divers provides diving services, such as underwater ship repairs, to its clients. The company's planning budget for May appears below: Puget Sound Divers Planning Budget For the month ended may 31 Budgeted diving-hours (4) nevenue ($410.000) Hages and salaries ($11,000+ $128.000) Supplies ($5.000) equipment rental ($2,100 - $24.000) Insurance ($4,000) Miscellaneous ($130+ $1.480) Total expenses net operating in one Puget Sound Divers Flexible Budget For the Month Ended May 1 $ 70,002 During May, the company's actual activity was 340 diving-hours. Required: Prepare a flexible budget for May Note: Round your answers to the nearest whole number Actual diving-hours Revenue Expenses Wages and salaries Supplies Equipment rent Insurance Miscellaneous 310 $ 143,100 Total expenses Net operating income 11,000 1,750 10,000 4,000

Exercise 9-1 (Algo) Prepare a Flexible Budget [LO9-1] Puget Sound Divers provides diving services, such as underwater ship repairs, to its clients. The company's planning budget for May appears below: Puget Sound Divers Planning Budget For the month ended may 31 Budgeted diving-hours (4) nevenue ($410.000) Hages and salaries ($11,000+ $128.000) Supplies ($5.000) equipment rental ($2,100 - $24.000) Insurance ($4,000) Miscellaneous ($130+ $1.480) Total expenses net operating in one Puget Sound Divers Flexible Budget For the Month Ended May 1 $ 70,002 During May, the company's actual activity was 340 diving-hours. Required: Prepare a flexible budget for May Note: Round your answers to the nearest whole number Actual diving-hours Revenue Expenses Wages and salaries Supplies Equipment rent Insurance Miscellaneous 310 $ 143,100 Total expenses Net operating income 11,000 1,750 10,000 4,000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Exercise 8-8 (Algo) Budgeted Income Statement [LO8-9] Gig Harbor Boating is the wholesale distributor of a small recreational catamaran sailboat. Management has prepared the following summary data to use in its annual budgeting process: Budgeted unit sales Selling price per unit Cost per unit Variable selling and administrative expense (per unit) Fixed selling and administrative expense (per year) Interest expense for the year Required: Prepare the company's budgeted income statement for the year. Gig Harbor Boating Budgeted Income Statement 740 $ 2,090 $ 1,490 $80 $ 345,000 25,000 B
Exercise 9-1 (Algo) Prepare a Flexible Budget [LO9-1] Puget Sound Divers is a company that provides diving services such as underwater ship repairs to clients in the Puget Sound area. The company's planning budget for May appears below: Budgeted diving-hours (q) Revenue ($470.00q) Puget Sound Divers Planning Budget For the Month Ended May 31 Expenses: Wages and salaries ($11,600+ $122.00q) Supplies ($4.00q) Equipment rental ($2,400 + $24.00q) Insurance ($4,100) Miscellaneous ($520+ $1.44q) Total expense Net operating income Puget Sound Divers Flexible Budget For the Month Ended May 31 Revenue Expenses: During May, the company's actual activity was 290 diving-hours. Required: Prepare a flexible budget for May. (Round your answers to the nearest whole number.) Wages and salaries Supplies Equipment rental Insurance Miscellaneous Total expense Net operating income $ 300 $ 141,000 0 0 48,200 1,200 9,600 4,100 952 64,052 $76,948
Puget Sound Divers is a company that provides diving services such as underwater ship repairs to clients in the Puget Sound area. The company’s planning budget for May appears below: Puget Sound DiversPlanning BudgetFor the Month Ended May 31 Budgeted diving-hours (q) 250 Revenue ($410.00q) $ 102,500 Expenses: Wages and salaries ($11,100 + $124.00q) 42,100 Supplies ($6.00q) 1,500 Equipment rental ($2,500 + $23.00q) 8,250 Insurance ($4,000) 4,000 Miscellaneous ($520 + $1.44q) 880 Total expense 56,730 Net operating income $ 45,770 During May, the company’s actual activity was 240 diving-hours. Required: Prepare a flexible budget for May.
None
None
Operating Budget, Comprehensive Analysis (5) The unit selling price of the wiring harness assembly is $110. In February, the company plans to purchase land for future expansion. The land costs $68,000. All sales and purchases are for cash. The cash balance on January 1 equals $62,900. The firm wants to have an ending cash balance of at least $25,000. If a cash shortage develops, sufficient cash is borrowed to cover the shortage and provide the desired ending balance. Any cash borrowed must be borrowed in $1,000 increments and is repaid the following month, as is the interest due. The interest rate is 12 percent per annum. Required: Prepare a monthly operating budget for the first quarter with the following schedules:
PR 9-37 (Algo) Completion of Budget Schedules (LO 9-3, 9-5, 9-6) Scholastic Furniture, Incorporated, manufactures a variety of desks, chairs, tables, and shelf units that are sold to public school systems throughout the Midwest. The controller of the company's Desk Division is currently preparing a budget for the second quarter of the year. The following sales forecast has been made by the division's sales manager. April May June 13,000 desk-and-chair sets 15,000 desk-and-chair sets 18,000 desk-and-chair sets Each desk-and-chair set requires 12 board feet of pine planks and 1.5 hours of direct labor. Each set sells for $50. Pine planks cost $.50 per board foot, and the division ends each month with enough wood to cover 10 percent of the next month's production requirements. The division incurs a cost of $22 per hour for direct-labor wages and fringe benefits. The division ends each month with enough finished-goods inventory to cover 20 percent of the next month's sales. Required:…
es w Exercise 9-1 (Algo) Prepare a Flexible Budget [LO9-1] Puget Sound Divers is a company that provides diving services such as underwater ship repairs to clients 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) Revenue ($390.00q) Expenses: Wages and salaries ($11,200 + $126.00q) Supplies ($4.00q) Equipment rental ($2,300 + $22.00q) Insurance ($4,200) Miscellaneous ($500+ $1.46q) Total expense Net operating income During May, the company's actual activity was 340 diving-hours. 350 $ 136,500 Puget Sound Divers Flexible Budget For the Month Ended May 31
Exercise 9-1 (Algo) Prepare a Flexible Budget [LO9-1] Puget Sound Divers is a company that provides diving services such as underwater ship repairs to clients 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 400 $ 176,000 Budgeted diving-hours (q) Revenue ($440.004) Expenses: Wages and salaries ($11,600+ $120.00q) Supplies ($4.000) Equipment rental ($2,300 + $25.009) Insurance ($4,000) Miscellaneous ($540 + $1.42q) Total expense Net operating income 59,600 1,600 12,300 4,000 1,108 78,608 $ 97,392 During May, the company's actual activity was 390 diving-hours. Required: Prepare a flexible budget for May. (Round your answers to the nearest whole dollar.) Puget Sound Divers Flexible Budget For the Month Ended May 31 Revenue Expenses: Wages and salaries Supplies Equipment rental Insurance Miscellaneous Total expense Net operating income
Problem 13-57 (Algo) Sales Expense Budget (LO 13-4) SPU, Ltd., has just recelved its sales expense report for January, which follows. Item Amount Sales commissions $370, 500 9e,400 Sales staff salaries Telephone and mailing Building lease payment 51, 000 60,000 19,100 8e, 000 33,750 51,190 Utilities Packaging and delivery Depreciation Marketing consultants You have been asked to develop budgeted costs for the coming year. Because this month is typical, you decide to prepare an estimated budget for a typical month in the coming year and you uncover the following additional data: Sales volume is expected to Increase by 14 percent. Sales prices are expected to decrease by 10 percent. Commissions are based on a percentage of sales revenue. • Sales staff salarles will increase 4 percent next year regardless of sales volume. • Bullding rent is based on a five-year lease that expires in three years. • Telephone and malling expenses are scheduled to Increase by 6 percent even with no change In…
Problem 8-30 (Algo) Integration of the Sales, Production, and Direct Materials Budgets [LO8-2, LO8-3, LO8-4] Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 36,000 October 26,000 August 82,000 November 12,500 September 51,000 December 13,000 The selling price of the beach umbrellas is $15 per unit. All sales are on account. Based on past experience, sales are collected in the following pattern: 30% in the month of sale 65% in the month following sale 5% uncollectible Sales for June totaled $465,000. The company maintains finished goods inventories equal to 15% of the following month’s sales. This requirement will be met at the end of June. Each beach umbrella requires 4 feet of…
Required information Skip to question [The following information applies to the questions displayed below.] Morganton Company makes one product and provided the following information to help prepare its master budget: The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and September are 8,600, 17,000, 19,000, and 20,000 units, respectively. All sales are on credit. Thirty percent of credit sales are collected in the month of the sale and 70% in the following month. The ending finished goods inventory equals 25% of the following month’s unit sales. The ending raw materials inventory equals 10% 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.40 per pound. Thirty five percent of raw materials purchases are paid for in the month of purchase and 65% in the following month. The direct labor wage rate is $14 per hour. Each unit of finished goods requires…