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 3 years 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...
Donna’s Fashions Corporation has the following sales forecast in units: January 1,000; February 800; March 900;...
Donna’s Fashions Corporation has the following sales forecast in
units:
January 1,000; February 800; March 900; April 1,400; May 1,550;
June 1,800; July 1,400
Donna always keeps ending inventory equal to 120 percent of the
next month’s expected sales. The ending inventory for December
(January’s beginning inventory) is 1,200 units, consistent with
company policy.
Materials cost $14 per unit and are paid for in the month after
production. Labour cost is $7 per unit and is paid in same month...
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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- What are the options that might be considered in relation to introducing flexible work practices? What...
- Question 2 : Aggregate Scores: Write a program that opens 2 files, quiz.txt, and hw.txt. The...
- Define the term symbiosis specifically as it applies in a biological context. Compare and contrast parasitism,...
- A research team conducted a study showing that approximately 20% of all businessmen who wear ties...
- Research the internet for companies that have executed data science projects. Pick one company and describe...
- Explain two theories or frameworks for understanding how Western Europe emerged out of 1,000 years of...
- Two cannons are mounted as shown in the drawing and rigged to fire simultaneously. They are...
ADVERTISEMENT