Concept explainers
Budget Performance Report for a Cost Center
The Eastern District of Adelson Inc. is organized as a cost center. The budget for the Eastern District of Adelson Inc. for the
month ended December 31 is as follows:
Sales salaries $819,840
System administration salaries 448,152
Customer service salaries 152,600
Billing salaries 98,760
Maintenance 271,104
Depreciation of plant and equipment 92,232
Insurance and property taxes 41,280
Total $1,923,968
During December, the costs incurred in the Eastern District were as follows:
Sales salaries $818,880
System administration salaries 447,720
Customer service salaries 183,120
Billing salaries 98,100
Maintenance 273,000
Depreciation of plant and equipment 92,232
Insurance and property taxes 41,400
Total $1,954,452
Required:
1. Prepare a budget performance report for the manager of the Eastern District of Adelson for the month of December.
Enter all amounts as positive numbers. If an amount box does not require an entry, leave it blank, or enter zero "0".
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 1 images
- At the beginning of the period, the Cutting Department budgeted direct labor of $58,500 and supervisor salaries of $48,860 for 3,250 hours of production. The department actually completed 3,500 hours of production. Determine the budget for the department assuming that it uses flexible budgeting.$fill in the blank 1arrow_forwardThe following information is from the manufacturing budget and budgeted financial statements of Altman Corporation: Direct materials inventory, 1/1 Direct materials inventory, 12/31 Direct materials budgeted for use during year Accounts payable to suppliers, 1/1 Accounts payable to suppliers, 12/31 For the year, budgeted cash payments to suppliers amounted to: $ 86,000 $ 102,000 $ 344,000 $ 54,000 $ 64,000arrow_forwardFor the year ending December 31, 2022, Concord Company accumulates the following data for the Plastics Division, which it operates as an investment center: contribution margin-$612,950 budget, $622,669 actual; controllable fixed costs-$302,000 budget, $305,500 actual. Average operating assets for the year were $2,073,000. Prepare a responsibility report for the Plastics Division beginning with contribution margin for the year ending December 31, 2022. (Round ROI to 1 decimal place, e.g. 1.5%.) CONCORD COMPANY Plastics Division Responsibility Report For the Year Ended December 31, 2022 Budget Actual Contribution Margin $ $ eTextbook and Media %24 %24 %24 %24 %24 > > >arrow_forward
- Phoenix Company reports the following fixed budget. It is based on an expected production and sales volume of 15,200 units. Sales Costs Direct materials Direct labor PHOENIX COMPANY Fixed Budget For Year Ended December 31 Sales staff commissions Depreciation-Machinery. Supervisory salaries Shipping Sales staff salaries (fixed annual amount) Administrative salaries Depreciation-office equipment Income $ 3,040,000 1,003, 200 212,800 45,600 295,000 202,000 228,000 246,000 457,400 198,000 $ 152,000 Problem 8-1A (Algo) Preparing and analyzing a flexible budget LO P1 Required: 1&2. Prepare flexible budgets at sales volumes of 14,200 and 16,200 units. 3. The company's business conditions are improving. One possible result is a sales volume of 18,200 units. Prepare a simple budgeted income statement if 18,200 units are sold. Complete this question by entering your answers in the tabs below.arrow_forwardGiven the following information, determine the activity rate for setups. Activity Total Activity-Base Usage Budgeted Activity Cost Setups 9,500 $57,700 Inspections 26,000 $140,600 Assembly (dlh) 70,400 $409,500 a.$5.41 b.$5.74 c.$5.82 d.$6.07arrow_forwardRelevant data from the Poster Company’s operating budgets are: Quarter 1 Quarter 2 Sales $208,480 $211,540 Direct material purchases 115,300 120,832 Direct labor 75,205 73,298 Manufacturing overhead 25,300 25,400 Selling and administrative expenses 33,400 33,500 Depreciation included in selling and administrative 1,500 900 Collections from customers 215,392 240,154 Cash payments for purchases 114,290 119,254 Additional data:Capital assets were sold in January for $10,000 and $4,400 in May.Dividends of $4,600 were paid in February. The beginning cash balance was $60,360 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the year: If an amount box does not require an entry, leave it blank. The Poster CompanyCash BudgetFor the First Two Quarters Quarter 1 Quarter 2 $Beginning Cash Balance $Beginning Cash Balance Add: Cash Receipts Collections from Customers…arrow_forward
- Given the following information, determine the activity rate for setups. Activity Total Activity-Base Usage Budgeted Activity Cost Setups 10,800 $58,100 Inspections 23,600 $142,200 Assembly (dlh) 76,400 $411,600 a.$5.38 b.$6.03 c.$5.52 d.$5.39arrow_forwardPLEASE HELP MEarrow_forward2 Arrangon Ltd. is a company that manufactures and sells a single product called Zoltar. For planning and control purposes they utilize a monthly master budget, which is developed in advance of the budget year. Their fiscal year end is September 30. A listing of the estimated ledger balances for the company's current year of September 30, 2024 is given below: Cash Accounts receivable Inventory-raw materials Inventory-finished goods Capital assets (net) $370,058 674,730 420,090 453,122 2,632,000 $4,550,000 The sales forecast consisted of these few lines: Accounts payable $719,488 Income tax payable 42,000 Capital stock Retained earnings 2.000.000 1,788,512 $4,550,000 • For the year ended September 30, 2024: 450,000 units at $42.00 each* For the year ended September 30, 2025: 475,000 units at $43.00 each . For the year ended September 30, 2026: 500,000 units at $44.00 each *Sales for the year ended September 30, 2024 are based on actual sales to date and budgeted sales for the duration…arrow_forward
- Use the following information for the Problems below. (Algo) Skip to question [The following information applies to the questions displayed below.] Phoenix Company reports the following fixed budget. It is based on an expected production and sales volume of 15,500 units. PHOENIX COMPANY Fixed Budget For Year Ended December 31 Sales $ 3,100,000 Costs Direct materials 992,000 Direct labor 232,500 Sales staff commissions 62,000 Depreciation—Machinery 295,000 Supervisory salaries 198,000 Shipping 217,000 Sales staff salaries (fixed annual amount) 251,000 Administrative salaries 498,500 Depreciation—Office equipment 199,000 Income $ 155,000 Problem 23-2A (Algo) Preparing a flexible budget performance report LO P1 Phoenix Company reports the following actual results. Actual sales were 18,500 units. Sales (18,500 units) $ 3,746,250 Costs Direct materials $ 1,198,800 Direct labor 284,900 Sales staff commissions 64,750…arrow_forwardSchool of Business and School of Education. Each of the operating departments uses the services of the company's two support departments: IT - Department and HR - Department. Additionally, the IT and HR departments use the services of each other. Data concerning the past year are as follows: Support Departments Operating Department IT HR School of School of Department HR - Dept. Business Education Total Budgeted Overhead Cost before any $437,500 $375,120 $ 825,250 $956,330 $2,594,200 departmental cost allocation Support work furnished by IT - Dept. Budgeted IT Salaries 0 $20,000 $80,000 $100,000 $200,000 Percentage 0 10.00% 40.00% 50.00% 100.00% Support work furnished by HR - Dept. Budgeted IT Service hours 1250 0 3,000 2,000 6, 250 Percentage 20.00% 0 48.00 % 32.00 % 100.00% Directions: 1. What are the total overhead costs of the operating departments (Business and Education) after the support - department costs of the IT Dept. and Human Resource Dept. have been allocated using (a)…arrow_forwardGiven the following information, determine the activity rate for setups. Activity Total Activity-Base Usage Budgeted Activity Cost Setups 9,900 $60,300 Inspections 24,900 $130,000 Assembly (dlh) 76,600 $389,000 a.$5.08 b.$6.09 c.$5.22 d.$5.20arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education