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 2 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...
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...
Wyatt Company has budgeted the following units sales for 2011: January 10,000 units February 8,000 units...
Wyatt Company has budgeted the following units sales for
2011:
January 10,000 units
February 8,000 units
March 9,000 units
April 11,000 units
May 15,000 units
Data regarding Finished Goods and Raw Materials Inventory is as
follows:
FINISHED GOODS:
The finished goods units on hand on December 31, 2010 was 2,000
units. Each unit required 2 pounds of raw materials that are
estimated to cost an average of $4 per pound. It is the company's
policy to maintain a finished goods...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Write a version of the binary search algorithm that can be used to search a string...
- Using the following reduction potentials: I2(s) + 2e- <---> 2I-(aq) E0 = 0.535 V I2 (aq)...
- Why are learnability and critical thinking crucial skills for the 21stcentury? And, how can you improve...
- Hudson Corporation is considering three options for managing its data warehouse: continuing with its own staff,...
- LUVE produces bracelets. Each band generates $460 in revenue and requires one ounce of gold as...
- (The following data apply to the next three questions.) Assume the following cost and revenue data...
- C# programming Create a classes called AlphabetDice that simulates a multi-sided dices with alphabet characters on...
ADVERTISEMENT