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
Sales 10,000 12,000 14,000 16,000

The ending inventory of finished goods for each quarter should equal 25% of the next quarter's budgeted sales in units. Four pounds of raw materials are required for each unit produced. Raw materials on hand at the start of the year total 4,200 pounds. The raw materials inventory at the end of each quarter should equal 10% of the next quarter's production needs in material.

What is scheduled production for third quarter?

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 2 years ago

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%...

Question