Jacob Long, the controller of Arvada Corporation, is trying to prepare a sales budget for the coming year. The income statements for the last four quarters follow: Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income First Quarter Second Quarter Third Quarter Fourth Quarter $ 187,000 (130,900) 56,100 (18,700) $ 217,000 (151,900) 65,100 (21,700) $ 227,000 (158,900) 68,100 (22,700) $ 37,400 $ 43,400 $ 45,400 $ 277,000 (193,900) 83,100 (27,700) $ 55,400 Total $ 908,000 (635,600) 272,400 (90,800) $ 181,600 Historically, cost of goods sold is about 70 percent of sales revenue. Selling and administrative expenses are about 10 percent of sales revenue. Fred Arvada, the chief executive officer, told Mr. Long that he expected sales next year to be 10 percent for each respective quarter above last year's level. However, Rita Banks, the vice president of sales, told Mr. Long that she believed sales growth would be only 5 percent. Required a. Prepare a pro forma income statement including quarterly budgets for the coming year using Mr. Arvada's estimate. b. Prepare a pro forma income statement including quarterly budgets for the coming year using Ms. Banks' estimate. Complete this question by entering your answers in the tabs below. Required A Required B Prepare a pro forma income statement including quarterly budgets for the coming year using Mr. Arvada's estimate. Sales revenue Cost of goods sold Second First Quarter Quarter Third Quarter Fourth Quarter Total
Jacob Long, the controller of Arvada Corporation, is trying to prepare a sales budget for the coming year. The income statements for the last four quarters follow: Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income First Quarter Second Quarter Third Quarter Fourth Quarter $ 187,000 (130,900) 56,100 (18,700) $ 217,000 (151,900) 65,100 (21,700) $ 227,000 (158,900) 68,100 (22,700) $ 37,400 $ 43,400 $ 45,400 $ 277,000 (193,900) 83,100 (27,700) $ 55,400 Total $ 908,000 (635,600) 272,400 (90,800) $ 181,600 Historically, cost of goods sold is about 70 percent of sales revenue. Selling and administrative expenses are about 10 percent of sales revenue. Fred Arvada, the chief executive officer, told Mr. Long that he expected sales next year to be 10 percent for each respective quarter above last year's level. However, Rita Banks, the vice president of sales, told Mr. Long that she believed sales growth would be only 5 percent. Required a. Prepare a pro forma income statement including quarterly budgets for the coming year using Mr. Arvada's estimate. b. Prepare a pro forma income statement including quarterly budgets for the coming year using Ms. Banks' estimate. Complete this question by entering your answers in the tabs below. Required A Required B Prepare a pro forma income statement including quarterly budgets for the coming year using Mr. Arvada's estimate. Sales revenue Cost of goods sold Second First Quarter Quarter Third Quarter Fourth Quarter Total
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter8: Budgeting For Planning And Control
Section: Chapter Questions
Problem 10CE: Coral Seas Jewelry Company makes and sells costume jewelry. For the coming year, Coral Seas expects...
Related questions
Question
Haresh
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning