Arragon Ltd. is a company that manufactures and sells a single product called Zoltar. For planning and control purposes they utilize a monthly master budget, which is developed in advance of the budget year. Their fiscal year end is April 30. The sales forecast consisted of these few lines: For the year ended April 30, 2023: 600,000 units at $27.00 each* For the year ended April 30, 2024: 630,000 units at $28.00 each. For the year ended April 30, 2025: 660,000 units at $29.00 each. Create sales budget

Arragon Ltd. is a company that manufactures and sells a single product called Zoltar. For planning and control purposes they utilize a monthly master budget, which is developed in advance of the budget year. Their fiscal year end is April 30. The sales forecast consisted of these few lines: For the year ended April 30, 2023: 600,000 units at $27.00 each* For the year ended April 30, 2024: 630,000 units at $28.00 each. For the year ended April 30, 2025: 660,000 units at $29.00 each. Create sales budget

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter7: The Master Budget And Flexible Budgeting

Section: Chapter Questions

Problem 1E: The sales department of Macro Manufacturing Co. has forecast sales for its single product to be...

See similar textbooks

Similar questions

The following data were obtained from the financial records of Sonicbrush, Inc., for March: Sales are expected to increase each month by 15%. Prepare a budgeted income statement.
The data shown were obtained from the financial records of Italian Exports, Inc., for March: Sales are expected to increase each month by 10%. Prepare a budgeted income statement.
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.
Palmgren Company produces consumer products. The sales budget for four months of the year is presented below. Company policy requires that ending inventories for each month be 25 percent of next months sales. At the beginning of July, the beginning inventory of consumer products met that policy. Required: Prepare a production budget for the third quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total.
A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000
Carmichael Corporation is in the process of preparing next years budget. The pro forma income statement for the current year is as follows: Required: 1. What is the break-even sales revenue (rounded to the nearest dollar) for Carmichael Corporation for the current year? 2. For the coming year, the management of Carmichael Corporation anticipates an 8 percent increase in variable costs and a 60,000 increase in fixed expenses. What is the break-even point in dollars for next year? (CMA adapted)
D’s Company Ltd expects to have a cash balance of $45000 on March 1, 2024.Relevant monthly budget data for the months of March and April are as follows:• Collections from customers: March $85000; April $150000• Payments for direct materials: March $50000; April $75000• Direct labour: March $30000; April $45000. Wages are paid in the month they are incurred.• Manufacturing overhead: March $21000; April $25000. These costs include depreciation of$1500 per month. All other overhead costs are paid as incurred.• Selling and administrative expenses: March $15000; April $20000. These costs are exclusive ofdepreciation. They are paid as incurred.• Sales of marketable securities in March are expected to be realised $12000 in cash.D’s Company Ltd. has a line of credit at a local bank that enables it to borrow up to$25000. Thecompany wants to maintain a minimum monthly cash balance of $20000. prepare cash budgets for march n april 2024
Lily Company expects to have a cash balance of $49,500 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $93,500, February $165,000. Payments for direct materials: January $55,000, February $82,500. Direct labor: January $33,000, February $49,500. Wages are paid in the month they are incurred. Manufacturing overhead: January $23,100, February $27,500. These costs include depreciation of $1,650 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $16,500, February $22,000. These costs are exclusive of depreciation. They are paid as incurred. Sales of marketable securities in January are expected to realize $13,200 in cash. Lily Company has a line of credit at a local bank that enables it to borrow up to $27,500. The company wants to maintain a minimum monthly cash balance of $22,000. Prepare a cash budget for January and February. LILY COMPANY Cash Budget…
The next two questions are based on the following information: Herald company, a jacket selling company, prepares its master budget for the year 2020 on a quarterly basis. The budget officer has gathered the following data: 1 Estimated Sales for each quarter is $230,000. All sales are on credit and all sales are collected in the following quarter. 2 Cost of goods sold for each quarter is $100,000. 3 Variable selling and adminstrative expenses for each jacket are 10% sales commission. 4 Fixed selling and adminstrative (S&A) expenses for the year are: Advertising 60,000 120,000 40,000 20,000 240,000 Executive salaries Insurance Depreciation Total fixed S&A expenses 5 The company expects to borrow $80,000 on April, 1, 2020. No principal will be repaid during the year; Interest rate at an annual rate of 10% is due quarterly. 6 The company will declare $3,000 dividend in December 2020, which will be paid in January 2021. 10 How much is the net income for the year 2020? А. $179,000 $182,000…
Shalom Company prepared the following sales budget for the first two quarters of 2023: January February March April 10,000 14,000 11,000 15,000 May 18,000 June 20,000 Unit sales Shalom Company sells the product at P15 per unit. 20% of sales is cash, and the balance is on credit. The company estimates that collection of sales on account will be 60% in the month of sales with the remainder in the following month. On December 31, 2022, accounts receivable was P60,000. Amounts must be in whole numbers. Example: 88,000 or (88,000) How much is the expected total cash receipts for January?
Shalom Company prepared the following sales budget for the first two quarters of 2023: January February March April May June 7,000 7,500 8,300 Unit sales 6,000 8,500 7,800 Shalom Company sells the product at P20 per unit. 20% of sales is cash, and the balance is on credit. The company estimates that collection of sales on account will be 60% in the month of sales with the remainder in the following month. In December 2022, total sales were P125,000. Amounts must be in whole numbers. Example: 88,000 or (88,000) 1. What is the balance of the accounts receivable on January 1, 2023? 2. How much is the expected total cash receipts for January? 3. How much is the expected total cash receipts for February? 4. How much is the expected total cash receipts for March? Item 1 Item 2 Item 3 Item 4
Coronado Company expects to have a cash balance of $41,400 on January 1, 2022. Relevant monthly budget data for the first 2 months of 2022 are as follows. Collections from customers: January $78,200, February $138,000. Payments for direct materials: January $46,000, February $69.000. Direct labor: January $27,600, February $41,400, Wages are paid in the month they are incurred. Manufacturing overhead: January $19,320, February $23,000. These costs include depreciation of $1,380 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $13,800, February $18,400. These costs are exclusive of depreciation. They are paid as Incurred. Sales of marketable securities in January are expected to realize $11.040 in cash, Coronado Company has a line of credit at a local bank that enables it to borrow up to $23,000. The company wants to maintain a minimum monthly cash balance of $18,400. Prepare a cash budget for January and February. CORONADO COMPANY…