Sheldon Industries' sales budget shows quarterly sales for 2020 as follows:QuarterFirstSecondThirdSales (Units)10,0008,00012,00014,000FourthCompany policy is to have a finished goods inventory at the end of each quarter equal to20% of the next quarter's sales. Prepare a production budget for the second quarter, ingood form.

Production budget is used for the identification and estimation of the cost. It determines how much…

Sheldon Industries' sales budget shows quarterly sales for 2020 as follows: Quarter First Second Third Fourth Sales (Units) 10,000 8,000 12,000 14,000 Company policy is to have a finished goods inventory at the end of each quarter equal to 20% of the next quarter's sales. Prepare a production budget for the second quarter, in good form.

Sheldon Industries' sales budget shows quarterly sales for 2020 as follows: Quarter First Second Third Fourth Sales (Units) 10,000 8,000 12,000 14,000 Company policy is to have a finished goods inventory at the end of each quarter equal to 20% of the next quarter's sales. Prepare a production budget for the second quarter, in good form.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Waterway Company prepares monthly cash budgets. Relevant data from operating budgets for 2027 are as follows. January February Sales $460,800 $512,000 Direct materials purchases 153,600 160,000 Direct labor 115,200 128,000 Manufacturing overhead 89,600 96,000 Selling and administrative expenses 101,120 108,800 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases are paid in cash in the month of purchase, and the balance due is paid in the month following the purchase. All other items above are paid in the month incurred except for selling and administrative expenses, which include $1,280 of depreciation per month. Other data: 1. Credit sales: November 2026, $320,000; December 2026, $409,600. 2. Purchases of direct materials: December 2026, $128,000. 3. Other receipts: January-Collection of December 31, 2026, notes…
Windsor Company is preparing its master budget for 2022. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales: Sales for the year are expected to total 1,200,000 units. Quarterly sales are 25%, 25%, 25%, and 25%, respectively. The sales price is expected to be $41 per unit for the first three quarters and $44 per unit beginning in the fourth quarter Sales in the first Quarter of 2023 are expected to be 10% higher than the budgeted sales for the first quarter of 2022 Production: Management desires to maintain the ending finished goods inventories at 20% of the next quarter's budgeted sales volume. Direct materials Each unit requires 2 kg of raw materials at a cost of $10 per kilogram. Management desires to maintain raw materials inventories at 10% of the next quarter's production requirements. Assume the production requirements for the first quarter of 2023 are 410.000 kg. Prepare the Sales Budget by quarter for 2022.
The total budgeted sales of Nana Kay Ltd for October, the first month of the last quarter in 2019 were GHS1,900,000. Sales are expected to increase by GHS100,000 in each month. Cash sales for each month are GHS200,000 and the remaining are credit sales. All the products are sold at a mark up of the cost plus 25 per cent. On average, Nana Kay Ltd collects 60 per cent of the credit sales in the month of sale and 35 per cent in the month following sales. The remainder is uncollectible. Determine the budgeted total cash receipt for each month of the last quarter of 2019 and the expected account receivables at the end of the quarter. (Show all workings clearly)
Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 111,000 Unit sales for December 2019 101,000 Expected unit sales for January 2020 113,000 Expected unit sales for February 2020 113,000 Expected unit sales for March 2020 118,000 Expected unit sales for April 2020 124,000 Expected unit sales for May 2020 137,000 Unit selling price $12 Waterways likes to keep 10% of the next month’s unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the month of sale, and 15% of the Accounts Receivable are collected in the month after sale. Accounts receivable on December 31, 2019, totaled $181,800.Direct MaterialsDirect materials cost 80 cents per pound. Two pounds of direct materials…
The total budgeted sales of Obaapa Ltd for April, the first month of the second quarter in 2021 were GHS950,000. Sales are expected to increase by GHS50,000 in each month. Cash sales for each month are GHS100,000 and the remaining are credit sales. All the products are sold at a mark up of the cost plus 25 per cent. On average, Obaapa Ltd collects 50 per cent of the credit sales in the month of sale and 45 per cent in the month following sales. The remainder is uncollectible. Determine the budgeted total cash receipt for each month of the second quarter of 2021 and the expected account receivables at the end of the quarter.
The following forecasted information was taken from the books of Pakhama Enterprises. Month 2020 Budgeted Sales(R)January 120 000February 140 000March 168 000April 144 000May 128 000June 100 000 The following information is also provided for Pakhama Enterprises:60% of all sales is on credit.Debtors are expected to pay their debts as follows:• 70% in the first month after the sale (after 30 days)• 20% in the second month after the sale (after 60 days)• 7 % in the third month after the sale (after 90 days)• 3% is irrecoverable Credit losses are written off at the end of the month in which the last instalment is received.Debtors will amount to R104 994 on 1 Jan…
Mallory Company expects to sell 130 units in the first quarter, and 70 units in the second quarter. Assuming the company prefers to maintain finished goods inventory equal to 40% of the next quarter's sales, prepare a production budget for the first quarter only. Hint: This quarter's projected sales were used to determine last quarter's required ending inventory. Mallory Company Production Budget First Quarter Budgeted Sales in units Add: desired ending finished goods inventory Total finished goods inventory needed Deduct: beginning finished goods inventory Units to be produced 1st Qtr.
Kipp Industries has the following production budget for 2022: 2022 Quarter 1 3,000 Units 2022 Quarter 2 8,000 Units 2022 Quarter 3 5,000 Units 2022 Quarter 4 6,000 Units 2023 Quarter 1 5,000 Units Each unit requires 2.5 hours of direct labor and workers are paid $20 per hour. Prepare a Direct Labor Budget for each of the quarters of 2022. (No need to show the total for the year).
Budget for the month of January 2020: beginning FG is 50,000 units; Sold units totaled 80,000 units and Ending FG in units is 40,000.Budgeted Cost of production are: DM is 20 per unit; DL of 30 per unit and VOH is 15 per unit. Budgeted FOH is 90,000.What is the budgeted production cost?
Anderson Manufacturing Inc., aims to prepare a cash budget for September 2020. The cash balance at the beginning of September is $9,000. The actual sales for July and August and expected sales for September are: Information Cah Sales Sales on Accoun 0000 60,00 Tetal Sales July (5 Augut (5) Septemberis 14,300 Sales on account are collected over a three-month period in the following ratio: 10% in the month of sale, 70% in the month following sale 18% in the second month following sale 2% remaining are uncollectible. Additional information includes: (a) Purchases of inventory will total S 50,000 for September; 20% will be paid for in September. Accounts payable from August's inventory purchases is $ 32,000, all of which will be paid in September. (b) Selling and administrative expenses are budgeted at $ 26,000 for September; of which $ 8,000 is for depreciation. (c) Equipment costing $ 36,000 will be purchased for cash during September, and other miscellancous cash expenses of $ 6,000…
In May 2022, the budget committee of Crane Stores assembles the following data in preparation of budgeted merchandise purchases for the month of June. 1. 2. 3. 4. (a) Expected sales: June $400,000, July $480,000. Cost of goods sold is expected to be 75% of sales. Desired ending merchandise inventory is 30% of the following (next) month's cost of goods sold. The beginning inventory at June 1 will be the desired amount. Compute the budgeted merchandise purchases for June. CRANE STORES Merchandise Purchases Budget $ $
Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2020: April May June Credit sales $ 312,000 $ 292,000 $ 352,000 Credit purchases 120,000 143,000 168,000 Cash disbursements Wages, taxes, and expenses 43,200 10,700 62,200 Interest 10,200 10,200 10,200 Equipment purchases 72,000 134,000 0 The company predicts that 5 percent of its credit sales will never be collected, 40 percent of its sales will be collected in the month of the sale, and the remaining 55 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2020, credit sales were $182,000, and credit purchases were $122,000. Using this information, complete the following cash budget. (Do not round intermediate calculations.)