The Northeast Regional Division of Union Corp. has been requested to prepare a quarterly budgeted income statement for 2020. The regional manager expects that sales in the first quarter of 2020 will increase by 10% over the same quarter of the preceding year and will then increase by 5% for each succeeding quarter in 2020. The corporate head office has requested that the regional manager maintain an inventory in dollars equal to 25% of the next quarter's sales. Quarterly purchases average 55% of quarterly sales. Budgeted ending inventory on December 31, 2019 is $176,000. Quarterly salaries are $20,000 plus 5% of sales. All salaries are classified as sales salaries. Other quarterly expenses are estimated to be as follows: Rent expense Depreciation on office equipment Utilities expense Miscellaneous expenses The income statement for the first quarter of 2019 was as follows: Sales $24,000 $12,000 $3,600 2% of sales Income Statement For the Quarter Ended March 31, 2019 Cost of goods sold Gross profit $720,000 396,000 324,000

The Northeast Regional Division of Union Corp. has been requested to prepare a quarterly budgeted income statement for 2020. The regional manager expects that sales in the first quarter of 2020 will increase by 10% over the same quarter of the preceding year and will then increase by 5% for each succeeding quarter in 2020. The corporate head office has requested that the regional manager maintain an inventory in dollars equal to 25% of the next quarter's sales. Quarterly purchases average 55% of quarterly sales. Budgeted ending inventory on December 31, 2019 is $176,000. Quarterly salaries are $20,000 plus 5% of sales. All salaries are classified as sales salaries. Other quarterly expenses are estimated to be as follows: Rent expense Depreciation on office equipment Utilities expense Miscellaneous expenses The income statement for the first quarter of 2019 was as follows: Sales $24,000 $12,000 $3,600 2% of sales Income Statement For the Quarter Ended March 31, 2019 Cost of goods sold Gross profit $720,000 396,000 324,000

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…
BCAS Ltd is developing a cash budget for April, May and June 2022, and the following information was gathered: Cash Receipts 1 Sales revenue for February and March 2022 are $200,000 and $180,000 respectively. The forecasted sales revenue for April, May and June 2022 are $170,000, $220,000 and $280,000 respectively. Historically, 30% of the firm’s sales are in cash, 60% are collected in the next month, and the remaining 10% are collected in the second month following the sale. 2 Monthly rental income received is $60,000. 3 Interest income of $10,000 will be received in May 2022. Cash Disbursements 4 The expected purchases are $150,000, $110,000 and $190,000 for the months of April, May and June 2022 respectively. The company pays all its purchases in the month of purchase. 5 Monthly salaries paid is $70,000. 6 Commission is paid to its salesman at 2% of current month’s sales. 7 Renovation of all retail outlets amounting to $400,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 $ $
Perez Company, which expects to start operations on January 1, 2018, will sell digital cameras in shopping malls. Perez has budgeted sales as indicated in the following table. The company expects a 12 percent increase in sales per month for February and March. The ratio of cash sales to sales on account will remain stable from January through March. Required a. Complete the sales budget by filling in the missing amounts. b. Determine the amount of sales revenue Perez will report on its first quarter pro forma income statement. Complete this question by entering your answers in the tabs below. Required A Required B Complete the sales budget by filling in the missing amounts. (Round intermediate calculations and final answers to 2 decimal places.) Sales January February March $ 46,000 116,000 Cash sales Sales on account Total budgeted sales $ 162,000
Lea Company's sales budget shows the following projections for the year ending Dec. 31, 2021: First quarter 40,000 units Third quarter 50,000 units Second quarter 55,000 units Fourth quarter 45,000 units The quantity of finished goods inventory at the end of each quarter is equal to 40% of the next quarter's budgeted unit sales and is constantly being maintained. What is the total production budget in units for one year ending Dec. 31, 2021 assuming that the estimated sales in units on the first quarter of 2022 is 50,000
Delta Manufacturing has budgeted the following unit sales: 2019 April May June July Units 25,000 40,000 60,000 45,000 Of the units budgeted, 40% are sold by the Coastal Division at an average price of $15 per unit and the remainder are sold by the Central Division at an average price of $12 per unit. Prepare separate sales budgets for each division and for the company in total for the second quarter of 2019.
Bravo Company is a bookstore that prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the first quarter: As of December 31, 2023 (the end of the prior quarter), the company’s general ledger showed the following account balances: Debit Credit Cash 44,000 Accounts Receivable 184,000 Inventory 60,000 Building & Equipment 404,000 Accumulated Depreciation 144,000 Accounts Payable 93,000 Capital shares 200,000 Retained Earnings 255,000 Totals $ 692,000 $ 692,000 Actual sales for December and budgeted…
Merchant Industries is preparing its master budget for 2016. Relevant data pertaining to its sales budget are as follows: Sales for the year are expected to total 8,000,000 units. Quarterly sales are 25%, 30%, 15%, and 30%, respectively. The sales price is expected to be $2.00 per unit for the first quarter and then be increased to $2.20 per unit in the second quarter. Instructions Prepare a sales budget for 2016 for Merchant Industries.
BCAS Ltd is developing a cash budget for April, May and June 2022, and the following information was gathered: Cash Receipts 1 Sales revenue for February and March 2022 are $200,000 and $180,000 respectively. The forecasted sales revenue for April, May and June 2022 are $170,000, $220,000 and $280,000 respectively. Historically, 30% of the firm’s sales are in cash, 60% are collected in the next month, and the remaining 10% are collected in the second month following the sale. 2 Monthly rental income received is $60,000. 3 Interest income of $10,000 will be received in May 2022. Cash Disbursements 4 The expected purchases are $150,000, $110,000 and $190,000 for the months of April, May and June 2022 respectively. The company pays all its purchases in the month of purchase. 5 Monthly salaries paid is $70,000. 6 Commission is paid to its salesman at 2% of current month’s sales. 7 Renovation of all retail outlets amounting to $400,000…