1 answer

Jacob Long, the controller of Arvada Corporation, is trying to prepare a sales budget for the...

Question:

Jacob Long, the controller of Arvada Corporation, is trying to prepare a sales budget for the coming year. The income stateme
Complete this question by entering your answers in the tabs below. 1452 Required A Required B Prepare a pro forma income stat
Required A Required B Prepare a pro forma income statement including quarterly budgets for the coming year using Ms. Bankss
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 $182,000 91,000 91,000 18,200 $ 72,800 Second Quarter $212,069 106,eee 106,000 21,200 $ 84,800 Third Quarter $ 222,000 111,000 111, 22,200 $ 88,800 Fourth Quarter $ 272,000 136,000 136,00 27,200 $108,800 Total $380,000 444,000 444,000 88,888 $355,200 Historically, cost of goods sold is about 50 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's estimate.
Complete this question by entering your answers in the tabs below. 1452 Required A Required B Prepare a pro forma income statement including quarterly budgets for the coming year using Mr. Arvada's estimate. First Quarter Second Quarter Third Quarter Fourth Quarter Total Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income Required B >
Required A Required B Prepare a pro forma income statement including quarterly budgets for the coming year using Ms. Banks's estimate. First Quarter Second Quarter Third Quarter Fourth Quarter Total . Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income < Required A

Answers

Answer

  • Requirement A

First Quarter

Second quarter

Third quarter

Forth Quarter

TOTAL

Sales Revenue

$200,200

$233,200

$244,200

$299,200

$976,800

Cost of Goods Sold

$100,100

$116,600

$122,100

$149,600

$488,400

Gross Profits

$100,100

$116,600

$122,100

$149,600

$488,400

Selling & Admin expenses

$20,020

$23,320

$24,420

$29,920

$97,680

Net Income

$80,080

$93,280

$97,680

$119,680

$390,720

  • Requirement B

First Quarter

Second quarter

Third quarter

Forth Quarter

TOTAL

Sales Revenue

$191,100

$222,600

$233,100

$285,600

$932,400

Cost of Goods Sold

$95,550

$111,300

$116,550

$142,800

$466,200

Gross Profits

$95,550

$111,300

$116,550

$142,800

$466,200

Selling & Admin expenses

$19,110

$22,260

$23,310

$28,560

$93,240

Net Income

$76,440

$89,040

$93,240

$114,240

$372,960

.

Similar Solved Questions

1 answer
How would earth move if the sun including its gravity suddenly disappeared
How would earth move if the sun including its gravity suddenly disappeared? Explain your answer....
1 answer
Suppose that NoP(X5)6 and P(X 2):2 find P( 3< X < 4).
Suppose that NoP(X5)6 and P(X 2):2 find P( 3< X < 4)....
1 answer
Simone is now 50 years old and plan to retire at age 67 (in 17 years)....
Simone is now 50 years old and plan to retire at age 67 (in 17 years). She currently has a share portfolio worth $750,000, a superannuation fund worth $1,200,000, and a money market (similar to cash) account worth $500,000. Her share portfolio is expected to provide annual returns of 12% p.a. (compo...
1 answer
The Saint Louis Rams nearly lost a play-off game after field-goal kicker Jeff Wilkins sent a...
The Saint Louis Rams nearly lost a play-off game after field-goal kicker Jeff Wilkins sent a 132 ft. field-goal attempt (that is, he kicked the ball from the 34 yard-line) straight into the goal-post cross-bar, which is 10 ft. above the ground. He kicked the 2 lb. ball at an angle of a = 30°. 10...
1 answer
How to slove it step by step 3. A large drug store offers a variety of...
how to slove it step by step 3. A large drug store offers a variety of products for sale. For 2018, the company reported: $10 million sales; $6 million variable costs; $2.4 million fixed costs. For 2019, what is the expected break-even sales in dollars)? (sales = $6 million]...
1 answer
The next two questions pertain to the following circuit, where the voltage ε delivered by the...
The next two questions pertain to the following circuit, where the voltage ε delivered by the battery is 60V, and R1=20Ω, R2=5Ω, and R3=6Ω. The current through R3 is Group of answer choices A 15A. B 12A. C 10A. D 8A. E 6 A. R1 R3 R2 ६ +...
1 answer
How do you use substitution to integrate #(x^2)(sinx^3) #?
How do you use substitution to integrate #(x^2)(sinx^3) #?...
1 answer
What does this youtube gray icon mean? I clicked on a video and it said something...
What does this youtube gray icon mean? I clicked on a video and it said something like "connecting to..." if I remember correctly. See the picture for the icon that I'm talking about....
2 answers
How fast is a wave if its frequency is 744.5 Hz and it has a wavelength of 163.1 m?
How fast is a wave if its frequency is 744.5 Hz and it has a wavelength of 163.1 m?...
1 answer
During the budget period, Tiger Manufacturing company expects to make $219,000 of sales on credit and...
During the budget period, Tiger Manufacturing company expects to make $219,000 of sales on credit and collect $143,500 of cash from customers. Assume no other cash inflows are expected, total cash payments during the budget period are expected to be $179,000 and an increase of $10,000 is desired in ...
1 answer
How do you simplify #(1-i)^31# ?
How do you simplify #(1-i)^31# ?...
1 answer
Process and detailed explanations required Bond Valuation: You currently own a 25-year maturity Government of Canada...
Process and detailed explanations required Bond Valuation: You currently own a 25-year maturity Government of Canada bond with a face value of $1000 that was issued Oct 15, 2015 (ie. 5 years ago) with a 6% coupon paid semi-annually. The current price of the bond is $1075. a) What is the current YTM ...
1 answer
How do you simplify #log_2 (7^2 * 4^7)#?
How do you simplify #log_2 (7^2 * 4^7)#?...
1 answer
Draw the Purchasing Power of Money, the Price/Quantity and the Quantity-of- Loanable Funds graphs for the...
Draw the Purchasing Power of Money, the Price/Quantity and the Quantity-of- Loanable Funds graphs for the case of an increasing demand of money and credit...
1 answer
Would this synthesis work? Ho ང་ ། —་ པསུང་
would this synthesis work? Ho ང་ ། —་ པསུང་...
1 answer
THIS IS AN ESSAY TYPE QUESTION Relative to the Sentencing Circle in the Hollow Water First Nation...
Question 1 THIS IS AN ESSAY TYPE QUESTION Relative to the Sentencing Circle in the Hollow Water First Nation Community Holistic Circle Healing Program, identify the program participants, seating orientation, and some of the preparations needed to conduct the circle THIS IS AN ESSAY TYPE QUESTION R...