Question

Axon Corporation, which has three divisions, is preparing its sales budget. Each division expects a different...

Axon Corporation, which has three divisions, is preparing its sales budget. Each division expects a different growth rate because economic conditions vary in different regions of the country. The growth expectations per quarter are 4 percent for Cummings Division, 2 percent for Springfield Division, and 5 percent for Douglas Division.

Division

First Quarter

Second Quarter

Third Quarter

Fourth Quarter

Cummings Division

$ 75,000

?

?

?

Springfield Division

  125,000

?

?

?

Douglas Division

  100,000

?

?

?

Required

  1. Complete the sales budget by filling in the missing amounts. (Round figures to the nearest dollar.)
  2. Determine the amount of sales revenue that the company will report on its quarterly pro forma income statements.

If cash collection happens as 25% of sales on cash; 50% collected in the month of the sale; 25% collected in the month following the sale, calculate the following:

  1. Total cash collections for Q2
  2. A/R for Q4
Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

In case of any doubts or Issues, please comment below

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Finch Company incurs annual fixed costs of $150,500. Variable costs for Finch’s product are $24.80 per...
Finch Company incurs annual fixed costs of $150,500. Variable costs for Finch’s product are $24.80 per unit, and the sales price is $40.00 per unit. Finch desires to earn an annual profit of $49,000. Use the per unit contribution margin approach to determine the sales volume in units and dollars required to earn the desired profit.(Do not round intermediate calculations. Round your final answers to the nearest whole number.) Sales in dollars Sales volume in units Gibson Company makes a...
The budget director of Heather’s Florist has prepared the following sales budget. The company had $370,000...
The budget director of Heather’s Florist has prepared the following sales budget. The company had $370,000 in accounts receivable on July 1. Heather’s Florist normally collects 100 percent of accounts receivable in the month following the month of sale. Required Complete the schedule of cash receipts by filling in the missing amounts. July August September Sales Budget Cash sales $72,000 $68,000 $86,000 Sales on account 86,000 107,000 121,600 Total budgeted sales $158,000 $175,000 $207,600 Schedule of Cash Receipts Current cash...
The budget director of Heather’s Florist has prepared the following sales budget. The company had $350,000...
The budget director of Heather’s Florist has prepared the following sales budget. The company had $350,000 in accounts receivable on July 1. Heather’s Florist normally collects 100 percent of accounts receivable in the month following the month of sale. Required Complete the schedule of cash receipts by filling in the missing amounts. Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet. 1. July August September Sales Budget Cash sales $67,000 $67,000...
HolidayHoliday Corporation has found that 6060 % of its sales in any given month are credit...
HolidayHoliday Corporation has found that 6060 % of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, HolidayHoliday Corporation has experienced the following collection pattern: 25% received in the month of the sale 50% received in the month after the sale 16% received two months after the sale 9% of the credit sales are never received November sales for last year were $ 90 comma 000$90,000 , while December sales...
Royal Cigar Company is preparing a budget for cash collections. Its sales for November and December...
Royal Cigar Company is preparing a budget for cash collections. Its sales for November and December are estimated as $120,000 and $136,000, respectively. Past practice indicates that sales in any given month are collected as follows: month of sale, 60%; month following the month of sale, 35%; uncollectible accounts, 5%. The company allows a 2% discount for cash collections in the month of sale. What is the net cash estimated to be collected in December? Net cash estimated collections:_________
Royal Cigar Company is preparing a budget for cash collections. Its sales for November and December...
Royal Cigar Company is preparing a budget for cash collections. Its sales for November and December are estimated as $130,000 and $148,000, respectively. Past practice indicates that sales in any given month are collected as follows: month of sale, 65%; month following the month of sale, 30%; uncollectible accounts, 5%. The company allows a 2% discount for cash collections in the month of sale. What is the net cash estimated to be collected in December?
Sweeney Corporation has found that 80​% of its sales in any given month are credit​ sales,...
Sweeney Corporation has found that 80​% of its sales in any given month are credit​ sales, while the remainder are cash sales. Of the credit​ sales, Sweeney Corporation has experienced the following collection​ pattern: 25% received in the month of the sale 50% received in the month after the sale 24% received two months after the sale 1% of the credit sales are never received November sales for last year were $90,000​, while December sales were $110,000. Projected sales for...
Circle A Company (XXX) is preparing its cash collections budget for the 2nd quarter of 2012.  ...
Circle A Company (XXX) is preparing its cash collections budget for the 2nd quarter of 2012.   Budgeted sales are as follows: Budgeted sales Apr May Jun Cash sales $10,000 $9,000 $7,500 Credit sales 24,000 20,000 16,500 Total sales $34,000 $29,000 $24,000 Accounts receivable at March 31 were $14,000. The budget assumes that 20% of credit sales are collected in the month of sale, and the remaining 80% are collected one month later. Please prepare the cash collections budget. For the...
Thornton Pointers Corporation expects to begin operations on January 1, 2019; it will operate as a...
Thornton Pointers Corporation expects to begin operations on January 1, 2019; it will operate as a specialty sales company that sells laser pointers over the Internet. Thornton expects sales in January 2019 to total $360,000 and to increase 15 percent per month in February and March. All sales are on account. Thornton expects to collect 68 percent of accounts receivable in the month of sale, 21 percent in the month following the sale, and 11 percent in the second month...
The Westwood Cycle Company expects to start operations on July 1, 2020 and will sell bicycles...
The Westwood Cycle Company expects to start operations on July 1, 2020 and will sell bicycles out of its store that it recently leased in the town center. Westwood Cycle has budgeted sales for the month of July to be $12,000 of which 30 percent will be cash sales and 70 percent will be sales on account. Westwood Cycle expects a 15 percent increase in sales per month for August and September with the ratio of cash sales to sales...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT