Question

In: Accounting

Q. Cabal makes a product that has the following information for the second quarter of 2018....

Q. Cabal makes a product that has the following information for the second quarter of 2018.

  

Jan feb march April May June July
Sales 10,000 11,400 12,100 13,300 15,000 13,600 14,400

They have a policy of keeping 20% of the next month's sales as a target ending inventory. The products require 2 hours of direct labour to make 1 unit at $20 per hour.

1.) Prepare a production budget for the second quarter.

2.) Prepare a labour usage budget and a purchases budget for the second Quarter.

Solutions

Expert Solution

1)
Production Budget
For the Second Quarter
April May June
Sales               13,300               15,000               13,600
Add:Ending Inventory                 3,000                 2,720                 2,880
Total Units available for sale               16,300               17,720               16,480
Less:Beginning Inventory                 2,660                 3,000                 2,720
Units to be produced               13,640               14,720               13,760
2) Labour Usage Budget
April May June
Units to be produced               13,640               14,720               13,760
Direct Labour per unit 2 2 2
Total Direct Labour               27,280               29,440               27,520
Labour cost per hour $ 20 $ 20 $ 20
Total Labour cost $       5,45,600 $       5,88,800 $       5,50,400

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

At the end of the second quarter of 20X1, Malta Corporation assembled the following information: The...
At the end of the second quarter of 20X1, Malta Corporation assembled the following information: The first quarter resulted in a $106,000 loss before taxes. During the second quarter, sales were $1,216,000; purchases were $666,000; and operating expenses were $336,000. Cost of goods sold is determined using the FIFO method. The inventory at the end of the first quarter was reduced by $20,000 to a lower-of-cost-or-market figure of $94,000. During the second quarter, replacement costs recovered, and by the end...
Chris Inc. has accumulated the following information for its second-quarter income statement for 20X2: Sales $...
Chris Inc. has accumulated the following information for its second-quarter income statement for 20X2: Sales $ 864,000 Cost of goods sold 434,000 Operating expenses 244,000 Additional Information First-quarter income before taxes was $114,000, and the estimated effective annual tax rate was 40 percent. At the end of the second quarter, expected annual income is $760,000, and a dividend exclusion of $46,000 and a business tax credit of $15,000 are anticipated. The combined state and federal tax rate is 50 percent....
For the second quarter of the following year Cloaks Company has projected sales and production in...
For the second quarter of the following year Cloaks Company has projected sales and production in units as follows: Jan Feb Mar Sales 56,000 58,000 63,000 Production 60,000 55,000 56,000 Cash-related production costs are budgeted at $8 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the next month. $170,000 per month will account for Selling and administrative expenses. On January 31 the accounts payable balance totals...
For the second quarter of the following year Cloaks Company has projected sales and production in...
For the second quarter of the following year Cloaks Company has projected sales and production in units as follows: Jan Feb Mar Sales 56,000 58,000 63,000 Production 60,000 55,000 56,000 Cash-related production costs are budgeted at $8 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the next month. $170,000 per month will account for Selling and administrative expenses. On January 31 the accounts payable balance totals...
For the second quarter of the following year Cloaks Company has projected sales and production in...
For the second quarter of the following year Cloaks Company has projected sales and production in units as follows: Jan Feb Mar Sales 56,000 58,000 63,000 Production 60,000 55,000 56,000 Cash-related production costs are budgeted at $8 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the next month. $170,000 per month will account for Selling and administrative expenses. On January 31 the accounts payable balance totals...
For the second quarter of the following year Cloaks Company has projected sales and production in...
For the second quarter of the following year Cloaks Company has projected sales and production in units as follows: Jan Feb Mar Sales 56,000 58,000 63,000 Production 60,000 55,000 56,000 Cash-related production costs are budgeted at $8 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the next month. $170,000 per month will account for Selling and administrative expenses. On January 31 the accounts payable balance totals...
Mercedes, Co. has the following quarterly financial information. 4th Quarter 3rd Quarter 2nd Quarter 1st Quarter...
Mercedes, Co. has the following quarterly financial information. 4th Quarter 3rd Quarter 2nd Quarter 1st Quarter Sales Revenue $ 925,800 $ 935,300 $ 933,600 $ 941,400 Cost of Goods Sold 305,700 318,300 317,900 323,100 Operating Expenses 248,900 260,300 258,500 262,600 Interest Expense 4,200 4,200 4,200 4,100 Income Tax Expense 85,500 88,400 88,400 90,900 Average Number of Common Shares Outstanding 799,030 794,064 795,670 809,000 Stock price when Q4 EPS released $ 24 Required: Calculate the gross profit percentage for each quarter....
Roberts Corporation makes one product and has provided the following information: a.    Each unit of finished...
Roberts Corporation makes one product and has provided the following information: a.    Each unit of finished goods requires 3 pounds of raw materials. The raw materials cost $5.00 per pound. b.   The direct labor wage rate is $24.00 per hour. Each unit of finished goods requires 2.8 direct labor-hours. c.    Manufacturing overhead is entirely variable and is $11.00 per direct labor-hour. d.   The variable selling and administrative expense per unit sold is $3.80. The fixed selling and administrative        expense...
Question 2 For the second quarter of the following year Cloaks Company has projected sales and...
Question 2 For the second quarter of the following year Cloaks Company has projected sales and production in units as follows: Jan Feb Mar Sales 58,000 60,000 65,000 Production 62,000 57,000 58,000 Cash-related production costs are budgeted at $8 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the next month. $190,000 per month will account for Selling and administrative expenses. On January 31 the accounts payable...
Santana Rey expects second-quarter 2018 sales of her new line of computer furniture to be the...
Santana Rey expects second-quarter 2018 sales of her new line of computer furniture to be the same as the first quarter’s sales (reported below) without any changes in strategy. Monthly sales averaged 42 desk units (sales price of $1,270) and 22 chairs (sales price of $520). Sales $194,340 COGS 145,440 Gross profit 48,900 Expenses Sales commissions (10%) 19,434 Advertising expenses 9,600 Other fixed expenses 18,600 Total expenses 47,634 Net income 1,266 * Reflects revenue and expense activity only related to...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT