Question
In: Accounting
The TS Corporation has budgeted sales for the year as follows: Quarter 1 2 3 4 Sales...
|
The TS Corporation has budgeted sales for the year as follows: Quarter 1 2 3 4 |
What is scheduled production for third quarter?
Solutions
Expert Solution
| Scheduled Prod in Q3 is 58000 Units | ||||
| Statement showing Budget | ||||
| Particulars | Q1 | Q2 | Q3 | Q4 |
| Sales | 10,000.00 | 12,000.00 | 14,000.00 | 16,000.00 |
| Ending inventory @25% | 3,000.00 | 3,500.00 | 4,000.00 | |
| Opening Inv= Ending of prev Quarter | 3,000.00 | 3,500.00 | 4,000.00 | |
| Production =Sales+End -Op | 12,500.00 | 14,500.00 | ||
| Pound reqd per unit | 4.00 | 4.00 | 4.00 | 4.00 |
| Total pounds reqd for prod | 50,000.00 | 58,000.00 | ||
| Raw Mat at end @10% | 5,000.00 | 5,800.00 | ||
| Opening raw Mat | 4,200.00 | 5,000.00 | 5,800.00 | |
| Purchases = Prod+cl-op | 50,800.00 |
ekkarill92 answered 3 years agoRelated Solutions
Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales...
Data
Year 2 Quarter
Year 3 Quarter
1
2
3
4
1
2
Budgeted unit sales
50,000
65,000
115,000
70,000
80,000
90,000
Selling price per unit
$7
per unit
1
Chapter 7: Applying Excel
2
3
Data
Year 2 Quarter
Year 3 Quarter
4
1
2
3
4
1
2
5
Budgeted unit sales
50,000
65,000
115,000
70,000
80,000
90,000
6
7
� Selling price per unit
$8
per unit
8
� Accounts receivable, beginning balance...
The Tobler Corporation has budgeted production for next year as follows: Quarter First Second Third Fourth...
The Tobler Corporation has budgeted production for next year as
follows:
Quarter
First
Second
Third
Fourth
Production in units
10,000
12,000
16,000
14,000
Four pounds of raw materials are required for each unit
produced. Raw materials on hand at the start of the year total
4,000 pounds. The raw materials inventory at the end of each
quarter should equal 20% of the next quarter's production needs.
Budgeted purchases of raw materials in the second quarter would
be:
Multiple Choice
63,200...
Chapter 9: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1...
Chapter 9: Applying Excel
Data
Year 2 Quarter
Year 3 Quarter
1
2
3
4
1
2
Budgeted unit sales
40,000
60,000
100,000
50,000
70,000
80,000
•
Selling price per unit
$8
per
unit
•
Accounts receivable, beginning balance
$65,000
•
Sales collected in the quarter sales are made
75%
•
Sales collected in the quarter after sales are made
25%
•
Desired ending finished goods inventory is
30%
of
the budgeted unit sales of the next quarter
•
Finished...
Chapter 8: Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1...
Chapter 8: Applying Excel
Data
Year 2 Quarter
Year 3 Quarter
1
2
3
4
1
2
Budgeted unit sales
40,000
60,000
100,000
50,000
70,000
80,000
• Selling price per unit
$8
per unit
• Accounts receivable, beginning
balance
$65,000
• Sales collected in the quarter sales are
made
75%
• Sales collected in the quarter after
sales are made
25%
• Desired ending finished goods inventory
is
30%
of the budgeted unit sales...
Year Quarter Sales 1 1 10 1 2 31 1 3 43 1 4 16 2...
Year
Quarter
Sales
1
1
10
1
2
31
1
3
43
1
4
16
2
1
11
2
2
33
2
3
45
2
4
17
3
1
13
3
2
34
3
3
48
3
4
19
4
1
15
4
2
37
4
3
51
4
4
21
a. Construct a time series plot. What type of pattern exists in
the data?
b. Use the following dummy variables to develop an estimated
regression equation to account for...
name: ___________________________________________________________ 1. Roberts has budgeted production for next year as follows: Quarter First Second Third...
name:
___________________________________________________________
1. Roberts has budgeted production for next year as follows:
Quarter
First
Second
Third
Fourth
Budgeted unit sales
9,000
11,000
12,000
14,000
Sales for each quarter of 2020 are listed above for a
manufacturing business. The ending finished goods requirement is
10% of the following month’s sales. Four pounds of
raw materials are required for each unit produced. The raw
materials inventory at the end of each quarter should equal
30% of the next quarter's production needs. The...
Flatiron Corp has the following budgeted sales in each quarter of the year 2020: Expected Sales...
Flatiron Corp has the
following budgeted sales in each quarter of the year 2020:
Expected Sales
Q1 $ 300,000
Q2 $ 320,000
Q3 $ 340,000
Q4 $ 360,000
Cash collection
information are as follows:
1. Of all sales, 80%
are on credit.
2. For the credit
sales made in the year 2020; 60% of credit sales are collected in
the quarter in which the sale is made; 30% are collected in the
following quarter; and 10% are collected in the...
unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 14,000 in quarter 3;...
unit sales will be 10,000 in quarter 1; 12,000 in quarter 2;
14,000 in quarter 3; and 18,000 in quarter 4. Management desires to
have an ending finished goods inventory equal to 10% of the next
quarter's expected unit sales. What is budgeted production in units
for quarter 2?
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 4...
Consider the following time series data.
Quarter
Year 1
Year 2
Year 3
1
2
4
5
2
4
5
8
3
1
3
4
4
7
9
10
(a)
Choose the correct time series plot.
(i)
(ii)
(iii)
(iv)
- Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)Item
1
What type of pattern exists in the data?
- Select your answer -Positive trend pattern, no
seasonalityHorizontal pattern, no seasonalityNegative trend
pattern, no seasonalityPositive trend pattern, with
seasonalityHorizontal pattern, with...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows:
Budgeted Sales in Units
March 12,000 units
April 24,000 units
May 35,000 units
June 13,000 units
July 43,000 units
August 69,000 units
ABC Company sells its inventory to customers for $25 per unit.
30% of the company's sales are cash sales and the other 70% of
sales are made on account. The sales on account are collected
in the pattern:
35% collected in the month of sale
26%...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Why does a particular codon represent only one specific amino acid?
- Write a function template sort that takes two references to generic objects and switches them if...
- What 2 things happen to the melting point of a solid when an impurity is present?
- How Can Hominin Evolution be characterized as " mosaic evolution" Use examples of species from the...
- Absorption and Variable Costing Income Statements for Two Months and Analysis During the first month of...
- Mobile and wireless devices are being increasingly used in the Business Administration and Management Industry. write...
- What are the options that might be considered in relation to introducing flexible work practices? What...
ADVERTISEMENT