Question
In: Accounting
Milton Inc. has prepared the following first quarter sales forecast: January 370 000 units February 485...
Milton Inc. has prepared the following first quarter sales forecast:
January 370 000 units
February 485 000 units
March 545 000 units
Each unit sells for $4.50.
The sales budget for the first quarter is:
|
$940 000 |
||
|
$4 900 000 |
||
|
$1 400 000 |
||
|
$6 300 000 |
Solutions
Expert Solution
Sales budget for the first quarter is $6,300,000
| January | February | March | Total | |
| Units | 370,000 | 485,000 | 545,000 | 1,400,000 |
| Sale Price | $4.50 | $4.50 | $4.50 | $4.50 |
| $1,665,000 | $2,182,500 | $2,452,500 | $6,300,000 | |
ekkarill92 answered 1 year agoRelated Solutions
Sales Forecasts for the first quarter of 2018: January 11 000 units February 13 000 units...
Sales Forecasts for the first quarter of 2018: January 11 000
units February 13 000 units March 14 000 units. Unit selling price
$100 Prepare the Sales Budget for Jan, Feb, and March. In addition
to the info in problem #1, the company requires jan 20% of next
month's budgeted sales as ending finished goods feb inventory each
month. Ending inventory for 12/31/17 was mar 2,200 units. The Sales
forecast for April is 20,000 units.
Lies Inc. prepared the following report for the first quarter of this year: Sales (2,500 units...
Lies Inc. prepared the following report for the first quarter of
this year:
Sales (2,500 units @ $2,800 per unit)
$7,000,000
Less: Cost of Goods sold
$3,840,000
Gross Margin
$3,160,000
Less:
Selling
Expense
$1,024,000
Administrative
Expense
$1,000,00
$2,024,000
Income
$1,136,000
Lie’s controller, Billy Baroo, studied the costs in detail,
particularly focusing on cost behaviour. Her analysis revealed the
following:
Sixty-five percent of the cost of goods sold was variable with
respect to the number of units.
Of the selling expenses,...
Heely Co. has the following projected sales in units for the first quarter of 20x2: January...
Heely Co. has the following projected sales in units for the
first quarter of 20x2:
January
10373
February
17195
March
12071
Heely Co.’s budget is based on the following assumptions: 36% of
all purchases of merchandise are paid in the month purchased and
the remainder in the following month. The number of units in each
month’s ending inventory is equal to 60% of the next month’s units
of sales.
The cost of each unit of inventory is $15.
What is...
Upward Inc. has projected sales to be 10,300 units in January; 12,400 units in February; 8,800...
Upward Inc. has projected sales to be 10,300 units in January;
12,400 units in February; 8,800 units in March; 10,600 units in
April; and 11,800 units in May. There are 860 units on hand on
January 1. Management has determined that it needs to carry 4% of
the following month’s sales in ending inventory. Assume that each
unit requires 4 litres of raw materials. There are 6,300 litres of
raw materials on hand at January 1. Management has decided that...
The following is the sales budget for Profit, Inc., for the first quarter of 2018: January...
The following is the sales budget for Profit, Inc., for the
first quarter of 2018:
January
February
March
Sales budget
$
213,000
$
233,000
$
256,000
Credit sales are collected as follows:
60 percent in the month of the sale
25 percent in the month after the sale
15 percent in the second month after the sale
The accounts receivable balance at the end of the previous
quarter was $97,000 ($67,000 of which was uncollected December
sales).
a.
Calculate the...
1. Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The...
1. Sales forecast: January: 2,600 units; February:
4,500 units; March: 10,200 units; April: 12,000 units. The unit
sales price is $125. All sales are on credit and collections are
30% in the month of sale, 60% the following month, and 10% two
months following the sale. Accounts receivable as of the end of
December is $4,600 and this amount is expected to be collected in
January.
2. End of month inventory must equal 40% of next month’s sales.
The inventory...
1. Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April: 12,000 units. The...
1. Sales forecast:
January: 2,600 units; February: 4,500 units; March: 10,200 units;
April: 12,000 units. The unit sales price is $125. All sales are on
credit and collections are 30% in the month of sale, 60% the
following month, and 10% two months following the sale. Accounts
receivable as of the end of December is $4,600 and this amount is
expected to be collected in January.
2. End of month inventory must equal
40% of next month’s sales. The inventory...
Information for 2020: 1. Sales forecast: January: 2,600 units; February: 4,500 units; March: 10,200 units; April:...
Information for 2020:
1. Sales forecast:
January: 2,600 units; February: 4,500 units; March: 10,200 units;
April: 12,000 units. The unit sales price is $125. All sales are on
credit and collections are 30% in the month of sale, 60% the
following month, and 10% two months following the sale. Accounts
receivable as of the end of December is $4,600 and this amount is
expected to be collected in January.
2. End of month inventory must equal
40% of next month’s...
Information for 2019: 1. Sales forecast: January: 2,100 units; February: 2,900 units; March: 3,300 units; April:...
Information for 2019:
1. Sales forecast:
January: 2,100 units; February: 2,900 units; March: 3,300 units;
April: 3,500 units. The unit sales price is $50. All sales are on
credit and collections are 20% in the month of sale and 80% the
following month. Accounts receivable as of December 31, 2018 is
$15,000 and this amount is expected to be collected in January
2019.
2. End of month inventory must equal
60% of next month’s sales. The inventory at the end...
Quagmire Inc. has prepared the following sales budget for the quarter of April, May and June:...
Quagmire Inc. has prepared the following sales budget for the
quarter of April, May and June:
Sales Budget
April
May
June
Total
Sales in units
10200
14400
12000
36600
Selling price per unit
x $30
x $30
x $30
Sales revenue
$306000
$432000
$360000
$1098000
All of the sales are on credit.
Quagmire collects from customers as follows:
40% of sales in the month of sale
25% in the month following the sale, and
35% in the second month following...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Proposition. You and your friends are learning to play hockey, and you decide to use physics...
- You have a wire of length L = 1.7 m for making a square coil of...
- A company. has a project available with the following cash flows: Year Cash Flow 0 −$31,430...
- Electrons are initially traveling at 2.40×106 m/s in the horizontal direction. They enter a region between...
- Create a Web application that display an animal classification. For the classification uses the given csv...
- considering Market growth, Market quality and Environmental aspects as three most important factors. For a good...
- A nozzle with a radius of 0.16 cm is attached to a garden hose with a...
ADVERTISEMENT