Problem 13-57 (Algo) Sales Expense Budget (LO 13-4)SPU, Ltd., has just recelved its sales expense report for January, which follows.ItemAmountSales commissions$370, 5009e,400Sales staff salariesTelephone and mailingBuilding lease payment51, 00060,00019,1008e, 00033,75051,190UtilitiesPackaging and deliveryDepreciationMarketing consultantsYou have been asked to develop budgeted costs for the coming year. Because this month is typical, you decide to prepare anestimated 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 sales volume. However, thesecosts are varlable with the number of units sold, as are packaging and delivery costs.Utilities costs are scheduled to increase by 4 percent regardless of sales volume.• Depreclatlon Includes furniture and fixtures used by the sales staff. The company has Just acquired an additlonal $61,000 Infurniture that will be recelved at the start of next year and will be depreciated over a 10-year life using the stralght-line method.• Marketing consultant expenses were for a special advertising campalgn that runs from time to time. During the coming year, thesecosts are expected to average $64,500 per month.Requlred:Prepare a budget for sales expenses for a typical month in the coming year. (Do not round Intermedlate calculatlons. Round yourfinal answers to nearest whole dollar amount.)Budgeted TypicalMonthItemSales commissionsSales staff salariesTelephone and mailingBuilding lease paymentUtilitiesPackaging and deliveryDepreciationMarketing consultantsTotal budgeted costs

Solution:- Given, SPU, Ltd., has just received its sales expense report for January You have been…

Required: Prepare a budget for sales expenses for a typical month in the coming year. (Do not round Intermediate calculations. Round your Tinal answers to nearest whole dollar amount.) Budgeted Typical Month Item Sales commissions Sales staff salaries Telephone and mailing Building lease payment Utilities Packaging and delivery Depreciation Marketing consultants Total budgeted costs

Required: Prepare a budget for sales expenses for a typical month in the coming year. (Do not round Intermediate calculations. Round your Tinal answers to nearest whole dollar amount.) Budgeted Typical Month Item Sales commissions Sales staff salaries Telephone and mailing Building lease payment Utilities Packaging and delivery Depreciation Marketing consultants Total budgeted costs

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

Oriole Enterprises reports all its sales on credit, and pays operating costs in the month incurred. Estimated amounts for the months of June through October are: August September October July $272800 $290400 $264000 $246400 $228800 $79200 June Budgeted sales Budgeted purchases $126720 $105600 $112640 O $279840. O $256080. O $158400. O. $274560. $116160 Customer amounts on account are collected 60% in the month of sale and 40% in the following month. Cost of goods sold is 45% of sales. Oriole purchases and pays for merchandise 30% in the month of acquisition and 70% in the following month. How much cash is budgeted to be received during August?
Saudi Agricultural Company, engaged in manufacturing bricks and other relevant items and most of the transaction accomplished in 'Cash' only. The company is giving following transactions for the year 2020, you are required to prepare 'CASH BUDGET' for three months from February to April. Following are company policies for paying and receiving Cash: 1. 20% Sales is for cash and the remaining amount is realized in the month following that of sales. Suppliers Supply raw materials at one month's credi 3. Wage-bill is paid in first week of next month. 4. Overheads are paid in cash in the same month. 5. Monthly rent payment is ` 1,000. 6. Advance Income Tax of ` 15,000 is payable in April. 7. Bonus of ` 10,000 is payable to workers in February. 8. Plant Costing 80,000 is due to be installed in February. The part of the bill will be paid in March amounting to ` 18,500. 9. Half year interest on 12% ` 50,000 Debentures is to be received in February and August every year. 10. Cash at Bank on 1st…
Required information SB Exercise E8-5 to E8-10 [The following information applies to the questions displayed below.] Shadee Corporation expects to sell 590 sun shades in May and 430 in June. Each shade sells for $135. Shadee's beginning and ending finished goods inventories for May are 90 and 55 shades, respectively. Ending finished goods inventory for June will be 70 shades. E8-10 (Algo) Preparing Budgeted Income Statement [LO 8-3h) Each shade requires a total of $45.00 in direct materials that includes 4 adjustable poles that cost $10.00 each. Shadee expects to have 120 in direct materials inventory on May 1, 100 poles in inventory on May 31, and 110 poles in inventory on June 30. Suppose that each shade takes three direct labor hour to produce and Shadee pays its workers $15 per hour. Additionally, Shadee's fixed manufacturing overhead is $11,000 per month, and variable manufacturing overhead is $11 per unit produced. Additional information: . Selling costs are expected to be 11…
Exercises 1: Questions for discussion 1. Describe the items reflected in the sales budget. 2. List the items included in the production budget 3. Identify the items that comprise the operating budget Exercises 2: Word Problems Roel Trading Company presents the actual sales for the first three months of year 2019 in its own products as follows: Product B P 540,000 P 567,000 P 595,350 Product A Total Sales Janaury February March P 880,000 P 941,000 P 1,006,750 The business expects that the trends for the past three months will P 340,000 P 374,000 P 411400 continue in April and May 2019. Required: Determined the projected sales for April and May 2019 for the two products. Round the amounts to thousand pesos.
Required information SB Exercise E8-5 to E8-10 [The following information applies to the questions displayed below.] Shadee Corporation expects to sell 570 sun shades in May and 330 in June. Each shade sells for $162. Shadee's beginning and ending finished goods inventories for May are 70 and 55 shades, respectively. Ending finished goods inventory for June will be 55 shades. E8-10 (Algo) Preparing Budgeted Income Statement [LO 8-3h] Each shade requires a total of $55.00 in direct materials that includes 4 adjustable poles that cost $5.00 each. Shadee expects to have 120 in direct materials inventory on May 1, 90 poles in inventory on May 31, and 100 poles in inventory on June 30. Suppose that each shade takes three direct labor hour to produce and Shadee pays its workers $15 per hour. Additionally, Shadee's fixed manufacturing overhead is $11,000 per month, and variable manufacturing overhead is $14 per unit produced. Additional information: • Selling costs are expected to be 8…
Required information SB Exercise E8-5 to E8-10 [The following information applies to the questions displayed below.] Shadee Corporation expects to sell 560 sun shades in May and 350 in June. Each shade sells for $142. Shadee's beginning and ending finished goods inventories for May are 70 and 50 shades, respectively. Ending finished goods inventory for June will be 55 shades. E8-10 (Algo) Preparing Budgeted Income Statement [LO 8-3h] Each shade requires a total of $50.00 in direct materials that includes 4 adjustable poles that cost $5.00 each. Shadee expects to have 120 in direct materials inventory on May 1, 100 poles in inventory on May 31, and 110 poles in inventory on June 30. Suppose that each shade takes three direct labor hour to produce and Shadee pays its workers $13 per hour. Additionally, Shadee's fixed manufacturing overhead is $10,000 per month, and variable manufacturing overhead is $15 per unit produced. Additional information: . Selling costs are expected to be 10…
Preparing an Accounts Payable Schedule Wight Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: April $374,400 May 411,100 June 416,700 Wight typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?
Preparing an Accounts Payable Schedule Wight Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: April $375,000 May 410,800 June 415,800 Wight typically pays 30% on account in the month of billing and 70% the next month. Required: 1. How much cash is required for payments on account in May?$fill in the blank 1 2. How much cash is expected for payments on account in June?$fill in the blank 2
Bugos Corporation is a sérvice company that measures its output by the number of customers served. The company has provided the following fixed and variable cost estimates that it uses for budgeting purposes. Variable Fixed Element Element per per Month Customer Served Revenue 4,200 Employee salaries and wages $ 58,800 006 Travel expenses Other expenses $ 33,300 When the company prepared its pianning budget at the beginning of March, it assumed that 40 customers would have been served. The amount shown for "Employee salaries and wages" in the planning budget for March would have been closest to: O $91,200 MacBook Air DD F10 08 F5 %24 %24 %24 %24
Alyeski Tours operates day tours of coastal glaciers in Alaska on its tour boat the Blue Glacier. Management has identified two cost drivers-the number of cruises and the number of passengers-that it uses in its budgeting and performance reports. The company publishes a schedule of day cruises that it may supplement with special sailings if there is sufficient demand. Up to 80 passengers can be accommodated on the tour boat. Data concerning the company's cost formulas appear below: Cost per Cruise $ 477.00 Cost per Passenger Fixed Cost per Month $ 6,000 $ 2,500 $ 5,300 $ 3,300 $ 3.00 Vessel operating costs Advertising Administrative costs $ 31.00 $ 1.50 Insurance For example, vessel operating costs should be $6,000 per month plus $477.00 per cruise plus $3.00 per passenger. The company's sales should average $31.00 per passenger. In July, the company provided 52 cruises for a total of 3,200 passengers. Required: Prepare the company's flexible budget for July. Alyeski Tours Flexible…
Mike Tackett, manager of the Troopers Cafe, hos asked for your assistance preparing the monthly budget fer January 20X8, He provides you with the prior lanuary actuls as fallows: Sales $100,400 Expenses: Labor (F 12,000 Labor (VI 18,000 Cost of sales IV) 36,000 Supplies IV) 3200 Encrgy (V) 2620 Promotion (V) Maintenance (F) 2.000 Maintenance (V) 1.200 Property tawes (F) 800 Depreciation (F) 1000 1.300 Rent IF) 850 Insurance (F) 625 Subtotal 72.595 Net income $ 20.005 Assume for 20X3 sakes are expected to increase by 10 percent, fined custs will increase by s percent, ard variable costs will remain at the same percentage of sa es as eperienced in the prior January. Prepare the budget for January 20X8.
SB Exercise E8-5 to E8-10 [The following information applies to the questions displayed below.] Shadee Corporation expects to sell 570 sun shades in May and 400 in June. Each shade sells for $143. Shadee's beginning and ending finished goods inventories for May are 65 and 50 shades, respectively. Ending finished goods inventory for June will be 60 shades. E8-10 (Algo) Preparing Budgeted Income Statement [LO 8-3h] Each shade requires a total of $50.00 in direct materials that includes 4 adjustable poles that cost $10.00 each. Shadee expects to have 130 in direct materials inventory on May 1, 100 poles in inventory on May 31, and 110 poles in inventory on June 30. Suppose that each shade takes three direct labor hour to produce and Shadee pays its workers $14 per hour. Additionally, Shadee's fixed manufacturing overhead is $9,000 per month, and variable manufacturing overhead is $10 per unit produced. Additional information: Selling costs are expected to be 9 percent of sales. Fixed…