Survey Of Accounting
5th Edition
ISBN: 9781259631122
Author: Edmonds, Thomas P.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Question
Chapter 14, Problem 15E
a)
To determine
Prepare the pro forma income statement including quarterly budgets as per Person A’s estimate
Given information:
Cost of goods sold is 60% of sales revenue
Selling and administration expenses are 10% of sales revenue
Expected sales by Person F is 8% and by Person B is 5%
b)
To determine
Prepare the pro forma income statement including quarterly budgets as per Person B’s estimate
Given information:
Cost of goods sold is 60% of sales revenue
Selling and administration expenses are 10% of sales revenue
Expected sales by Person F is 8% and by Person B is 5%
c)
To determine
The reason for the different estimates by two officers
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Question 1
The marketing department of HASF Corporations has submitted the following sales forecast for the upcoming fiscal year (all sales are on account)
Q1
Q2
Q3
Q4
total
Budgeted units sales
?
10% increase
10 % decrease
16,335
62,685
Budget selling price per unit
18
18
18
?
18
budgeted sales revenue
?
297,000
?
294,030
?
Other information
Each quarter ending finished goods inventory is 20% of next month units sold.
Next year first quarter beginning inventory is 3,000.
Each finished units require 3 grams of raw material that cost Rs 3 per unit.
Management desired to end each quarter with an inventory of raw material equal to 15% of the current quarter production needs
Beginning inventory of raw material in first quarter 3,000 grams
FIND UNIT SALES of Q1
Answer format should be like : 10000 donot USE COMMA's or Currency or UNITs. Answer should be plain…
Question 3
Relevant data from Picta Company’s operating budgets are presented below. The company’s financial year ends on 30 June.
Quarter 1
Quarter 2
Sales
$248,470
$251,539
Direct material purchases
120,295
128,832
Direct labor
76,553
74,289
Manufacturing overhead
26,000
24,400
Selling and administration expenses
33,500
33,500
Depreciation included in selling and administration expenses
2,000
2,500
Collection from customers
230,524
220,116
Cash payments for purchases
114,345
118,346
Additional data:
Equipment was sold in July for $8,000 and $4,500 in November. Dividends of $5,500 were paid in August. The beginning cash balance was $80,395 and a required minimum cash balance per quarter is $60,000.
The company has a 15% open line of credit for $70 000 with their bank.…
Exercise 6 (Selling and Administrative Budget)
The budgeted unit sales of Helene Company for the upcoming fiscal year are
provided below:
3rd quarter
11,000
4th
quarter
1s' quarter
12,000
2nd quarter
14,000
Budgeted unit sales
10,000
The company's variable selling and administrative expenses per unit are P2.75.
Fixed selling and administrative expenses include advertising expenses of
P12,000 per quarter, executive salaries of P40,000 per quarter, and
depreciation of P16,000 per quarter. In addition, the company will make
insurance payments of P6,000 in the 2nd Quarter and P6,000 in the 4th Quarter.
Finally, property taxes of P6,000 will be paid in the 3rd Quarter.
Chapter 14 Solutions
Survey Of Accounting
Ch. 14 - Prob. 1QCh. 14 - Prob. 2QCh. 14 - 3.What are the three levels of planning? Explain...Ch. 14 - 4.What is the primary factor that distinguishes...Ch. 14 - 5.What is the advantage of using a perpetual...Ch. 14 - Prob. 6QCh. 14 - Prob. 7QCh. 14 - 8. Ken Shilov, manager of the marketing...Ch. 14 - Prob. 9QCh. 14 - 10.What is the normal starting point in developing...
Ch. 14 - 11. How does the level of inventory affect the...Ch. 14 - 12.What are the components of the cash budget?...Ch. 14 - 13.The primary reason for preparing a cash budget...Ch. 14 - 14.What information does the pro forma income...Ch. 14 - 15.How does the pro forma statement of cash flows...Ch. 14 - Exercise 7-1A Budget responsibility Teresa...Ch. 14 - Exercise 7-2A Preparing a sales budget Parliament...Ch. 14 - Prob. 3ECh. 14 - Exercise 7-4A Preparing sales budgets with...Ch. 14 - Exercise 7-5A Determining cash receipts from...Ch. 14 - Exercise 7-6A Using judgment in making a sales...Ch. 14 - Exercise 7-7A Preparing an inventory purchases...Ch. 14 - Exercise 7-8A Preparing a schedule of cash...Ch. 14 - Exercise 7-9A Determining the amount of expected...Ch. 14 - Exercise 7-10A Preparing inventory purchases...Ch. 14 - Exercise 7-11A Preparing a schedule of cash...Ch. 14 - Prob. 12ECh. 14 - Exercise 7-13A Preparing a cash budget The...Ch. 14 - Exercise 7-14A Determining amount to borrow and...Ch. 14 - Prob. 15ECh. 14 - Problem 7-16A Behavioral impact of budgeting...Ch. 14 - Prob. 17PCh. 14 - Problem 7-18A Preparing an inventory purchases...Ch. 14 - Prob. 19PCh. 14 - Problem 7-21A Preparing a cash budget Fayette...Ch. 14 - Prob. 21PCh. 14 - Problem 7-22A Preparing budgets with multiple...Ch. 14 - Problem 7-23A Preparing a master budget for retail...Ch. 14 - ATC 7-1 Business Applications Case Preparing and...Ch. 14 - ATC7-2 Group Assignment Master budget and pro...Ch. 14 - ATC 7-4 Writing Assignment Continuous budgeting...Ch. 14 - Ethical Dilemma Bad budget system or unethical...
Knowledge Booster
Similar questions
- Question 1 View Policies Current Attempt in Progress Heaters, Inc. provided the following budgeted information for March through July July June May April March $104,600 $123,000 $115,000 $132,000 $141,400 Projected sales Projected merchandise purchases $82,000 $92,400 $75,300 $66,600 $73,000 $12,000 $13,600 $11,300 $12,400 $14,300 Inventory at end of month . Heaters estimates that it will collect 30% of its sales in the month of sale and 70% in the month after the sale . General operating expenses are budgeted to be $31,000 per month of which depreciation is $3,000 of this amount. Heater pays operating expenses in the month incurred . The income tax rate is 30%. How much is budgeted net income for May? $4,480. O $6,400. $6,090. O $8,400. A hp fs + f6 ins prt sc fio fn 12 home delete II & 7 6 8 backspace loc Parrow_forwardExercise 7-48 Preparing sales budgets with different assumptions Plano International Company has three subsidiaries, Seymour Trading Company, Archer Medical Supplies Company, and Milsap Shipping Company. Because the subsidiaries operate in different industries, Plano's corporate budget for the coming year must reflect the different growth potentials of the individual industries. The growth expectations per quarter for the subsidiaries are 4 percent for Seymour, 1 percent for Archer, and 3 percent for Milsap. Subsidiary Current Quarter Sales First Quarter Second Quarter Third Quarter Fourth Quarter Seymour $100,000 Archer 120.000 Milsap 160.000 ? ? ? ? Required a. Complete the sales budget by filling in the missing amounts. (Round the figures to the nearest dollar) b. Determine the amount of sales revenue Plano will report on the quarterly pro forme income statements.arrow_forwardQuestion 2 The accountant for ABX Limited compiled the following cost information regarding the budgetary period of four moths. Sales in Kgs are expected to be 2000 per month for Jan, Feb, Mar and April. The selling price of K10 per Kg will remain uniform throughout the four months. The company is expected to have cash at hand of K15,000 at the beginning of the period. ABX Limited is expecting a particular debtor to settle his outstanding amount in January for K12,000. The possibility of collecting this amount is 100%. The accountant has also noted the following: The company will hire a grader for the first two months at K2000 per month. Prepared electricity will be paid only in Mar and April at K3000 for each month. Wages and salaries are expected to be K3500 on a monthly basis. Stationery is budgeted at K1,500 in month one and K2500 in month 2 and 3. Transport and fuel is expected to be K2500 per month for the entire period Repairs and maintenance for the build will…arrow_forward
- Question 32 The following information is taken from the production budget for the first quarter: Sales budgeted for the quarter 684,000 units Desired ending finished goods Beginning inventory in units 4,800 units 1,800 units How many units should the company produce during the quarter? 681,000 a. Ob. 688,800 Oc. 687,000 711,000arrow_forwardQuestion 8 Forty percent of Soft Company’s sales are for cash and 60% are on account. Fifty percent of the account sales are collected in the month of sale. 30% in the month following sale and 20% in the second month following sale. The following are budgeted sales data for the company. January – P60,000 February – P40,000 March – P50,000 Total cash receipts in March are expected to be?arrow_forwardQuestion 2 View Policies Current Attempt in Progress Drew 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 June $310,000 $330,000 $300,000 $280,000 $260,000 Budgeted sales Budgeted purchases $144,000 $120,000 $128,000 $132,000 $90,000 . 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. . Drew 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? $312,000. O $318,000. O $291,000. $180,000. ) hp 19 4 fn + ins prt sc delete home end & 7 6 num backspace lock P home H J K 4 enterarrow_forward
- Problem 5 Prepare a cash budget by month for the month quarter ending September 30, 2009, from the following data obtained from the Peninsula Co. Support your solution with schedules of estimated receipts & payments. August P 16,000 150,000 120,000 18,000 2,000 July P 12,000 110.000 90,000 Operating Expenses 15,000 September P 18,000 120,000 110,000 16,000 Cash sales Credit sales Purchases Interest expense Credit are collected 50% in the month of sales. 40% in the month following, 8% in the second month following and 2% uncollectible. Credit sales for May and June are expected to be P100,000 and P90,000 respectively. Purchases of merchandise, all on account are paid 60% in the month of purchase and 40% in the month fallowing. Purchase for June are estimated at 80,000 are paid in the month incurred. Cash balance on June 30, 2009 is P27,000.arrow_forwardChapter 9 Profit Planning and Flexible Budgets Brief Exercise 9-24 Preparing a Direct Labor Budget 1.4 Patrick Inc. makes industrial solvents. Planned production in units for the first 3 months of the coming year is: January February 43,800 41,000 March 50,250 Each drum of industrial solvent takes 0.3 direct labor hour. The average wage is $18 per hour. Required: Prepare a direct labor budget for the months of January, February, and March, as well as the total for the first quarter. Brief Exercise 9-25 Preparing an Overhead Budget 9.5 Patrick Inc. makes industrial solvents. Budgeted direct labor hours for the first 3 months of the coming year are: 13,140 January February 12,300 March 15,075 The variable overhead rate is $0.70 per direct labor hour. Fixed overhead is budgeted at $2,750 per month. Required: Prepare an overhead budget for the months of January, February, and March, as well as the total for the first quarter. (Note: Round all dollar amounts to the nearest dollar.)arrow_forwardA company expects the following sales for the coming year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units 50,000 40,000 70,000 90,000 Average selling price $6 $6 $6 $8 Budgeted sales revenue for the year is: a. $1,050,000. b. $1,260,000. c. $1,155,000. d. $1,680,000. e. It is impossible to tell from this information.arrow_forward
- Assignment Four A manager is preparing a revenue budget for next month. The following is the manager's current month actual operating results. ACTUAL OPERATING RESULTS CURRENT MONTH Revenue Source Number of Guests Restaurant Lounge Banquet room Total NEXT MONTH BUDGET Revenue Source 3492 515 388 4395 Restaurant Lounge Banquet room Total Average Sale per Guest Number of Guests $20.50 $12.00 $28.50 $20.21 Create the revenue forecast for next month based on the following assumptions. A. Restaurant guest counts will be 3,600 with an average sale per guest of $21.00. B. Lounge guests to be served are estimated at 525 with a 10 percent increase in average sale per guest. C. The banquet room will serve 425 customers and generate $12,750 in sales. Sales Average Sale per Guest $71,586 $6,180 $11,058 $88,824 Sales 1. What will be the manager's revenue forecast for next month? 2. What will be the manager's average sale per guest forecast for next month? 3. What is the overall percentage increase…arrow_forwardQuestion 7 Landon Inc. projected sales of 31,000 personal journals for 20Y6. The estimated January 1, 20Y6, inventory is 2,200 units, and the desired December 31, 20Y6, inventory is 3,000 units. What is the budgeted production (in units) for 20Y6?fill in the blank 1 unitsarrow_forwardExercise 6 (Selling and Administrative Budget) The budgeted unit sales of Helene Company for the upcoming fiscal year are provided below: 1stquarter 2ndquarter 3rd quarter 4th quarter Budgeted unit sales..... 12,000 14,000 11,000 10,000 The company's variable selling and administrative expenses per unit are P2.75. Fixed selling and administrative expenses include advertising expenses of P12,000 per quarter, executive salaries of P40,000 per quarter, and depreciation of P16,000 per quarter. In addition, the company will make insurance payments of P6,000 in the 2nd Quarter and P6,000 in the 4thQuarter. Finally, property taxes of P6,000 will be paid in the 3rd Quarter. Required: Prepare the company's selling and administrative expense budget for the upcoming fiscal year.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- 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
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education