Q # 2 The following information has been accumulated by budget department for future sales and production requirements: Expected Sales for 2010 Product Sales (units) Price (Rs.) Expected Inventories for Jan. 01, 2010 Desired Inventories for Dec. 31, 2010 X 30,000 50 10,000 units 12,000 units Y 50,000 60 15,000 20,000 units Z 30,000 70 7,000 8,000 units Required
Q: Q # 1 Quarterly Sales Budget by Cities Inventories Schedule Estimated sales percentages for the…
A: Sales budget in the business shows expected units to be sold out and expected selling price per unit…
Q: Forecast Sales Volume and Sales Budget For 20Y8, Raphael Frame Company prepared the sales budget…
A:
Q: Question 1 View Policies Current Attempt in Progress Heaters, Inc. provided the following budgeted…
A: Budgeted net income has to determined by deducting projected expenses and cost of goods sold from…
Q: Required: glored. 00. nidam aillim olgmoo Using Schedule 1 as your guide, prepare a schedule of…
A: Budget: Budget is an effective tool to achieve the financial and operational goals of the business.…
Q: Construct the MOH budget Year 2 Quarter 1 2 3 4 Year Budgeted direct labor-hours Variable…
A: Manufacturing overhead budget contains all the costs of production other than raw materials and…
Q: E1 1 To ald in planning, Jay Corporation is preparing a contributon format income statement. 3…
A: Contribution margin=Sales-Total variable expensesNet operating income=Contribution margin-Total…
Q: if the recession led Shalimar's top management to assume that in the next year 10 percent of credit…
A: Cash Receipt Budget is the pre estimation of the total cash receipts from the sales of products,…
Q: Q8) Prepare a cash budget for the first quarter for Shamz Logistics Inc., given the following data.…
A: Cash Budget is a statement of forecast to estimate the receipts and disbursement of cash for an…
Q: Estimated sales for January: Birdhouse 7.500 units at $66…
A: The budget is prepared to estimate the requirements for the future period.
Q: Question 1 Syntex Corporation has the following Production Budget data: Expected Sales in Units…
A: Hi! Thank you for the question, As per the honor code, we'll answer the first question since the…
Q: ABC produces Goods for resale at throughout America. The company is currently in the process of…
A: Expected unit sales for first quarter =Prior unit sales of first quarter +(Prior unit sales of first…
Q: Compile AnYeLiR's Cash Budget. Co. for March, April and May. The company had sales in January and…
A: Cash budget refers to an estimation of cash inflows and outflows in a business over a specified…
Q: Prepare a budgeted income statement for the year. E10.26 (LO 3) Haven Company has accumulated the…
A: An income statement is a financial report that indicates the revenue and expenses of a business. It…
Q: 4. Using the provided budgeted information for production of 10,000 and 15,000 units, prepare a…
A: A flexible budget is the most accurate way of budgeting for the manufacturing business that does not…
Q: Question 3 The following information is budgeted for Aracker Sdn Bhd (ASB) for second quarter next…
A: Cash budget is very important budget which shows all cash receipts and all cash payments that is…
Q: Inventory of finished goods on June 30, 2010, is budgeted at 1,000 units. Management would like the…
A: A budget is defined as an estimate of revenue income and expenses for a set period of time. The…
Q: Ch. 8 Homework Budgeted Total Sales/Budgeted Production Please solve and explain the answers to the…
A: 1. Compute Shadee’s budgeted total sales for May and June as shown below: Therefore, total…
Q: Question 23 ncements -/1 sions View Policies rences Current Attempt in Progress orations Swifty…
A: Budgeted cash receipts are the cash inflows expected for the budgeted period.
Q: Required: prepare budget of purchase for each of the first three months of 2011 prepare separate…
A: The details of budget for the year 2011 are given. Required prepare budget of purchase for each…
Q: QUESTION2…
A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…
Q: B.2.B. The budget committee of Red Rose Company has the following data for preparing budgeted income…
A: In order to compute the Gross profit earned by the business entity, the cost of goods sold should be…
Q: Q.No. 2 Abuhatim LLC has given the following particulars. You are required to prepare a cash budget…
A: cash budget: The cash budget refers to the projection of cash movement of a business over a specific…
Q: QUESTION 1 New Norm Fashion produces washable face mask shield. The following budgeted/ actual…
A: First we will prepare income statement using absorption costing. However, before creating income…
Q: Michael Cage Manufacturing Company sells birdhouses. The company has prepared the following forecast…
A: The budgeted sales along with beginning inventory and ending inventory can be used to determined the…
Q: ABC produces Goods
A: Since you have asked multiple parts in a question, we will solve the first two parts for you. if you…
Q: The following information has been by New Inc. in preparing its budget for November and December…
A: Variable factory overheads refer to those expenses that relate directly to the manufacturing output.…
Q: Expert Q&A Done Problem 4-25 Complete cash budget [LO4-2] Harry's Carryout Stores has eight…
A: A cash budget is an estimate of a corporation's cash flows for a given time span. A cash budget is…
Q: he following information has been accumulated by budget department for future sales and production…
A: A budget is a forecasted estimate that helps in the process of reducing cost and improving profit…
Q: Q1; Waroad Company's sales budget projects unit sales of part CB78 of 10,000 units in January,…
A: Budget may be defined as that type of financial planning which is concerned with the acquisition,…
Q: II. FILL in the Table below. SAFARRI COMPANY Sales Budget For the Year Ending December 31, 2020…
A: solution : given SAFARRI COMPANY…
Q: Q # 2 The following information has been accumulated by budget department for future sales and…
A: Sales budget shows how much units are expected to be sold out and what will their selling price.…
Q: -/1 Question 13 View Policies Current Attempt in Progress The following information is taken from…
A: The production budget refers to that budget which forecasts the production for the future accounting…
Q: 2. Al Nebras Company has budgeted production for next year as follows: 1st Year Q1 30,000 Q2 40,000…
A: The question is Multiple choice question.The question is related to Budgetory Control. The details…
Q: Q3. Central Trading LLC, Oman operates in three countries UAE, India and Oman, which sells three…
A: please give a like, your response matters In order to prepare the budget for current year as well as…
Q: Daybook Inc. projected sales of 400,000 personal journals for 20Y6. The estimated January 1, 20Y6,…
A: Budgeted production (in units) = Budgeted sales + Desired ending inventory - Beginning Inventory
Q: Question 20 /1 View Policies Current Attempt in Progress Vaughn Manufacturing budgets on an annual…
A: A Budget statement is a proper articulation of assessed income and costs dependent on tentative…
Q: QUESTION 7 BMW Limited manufactures a single product, Tune. The finance director prepares monthly…
A: Budgets are very important in business, they provide base for future that how much units needs to be…
Q: A company manufactures a single product. Budget and Standard cost details for next year include:…
A: asdf
Q: Fantastic Cement Manufacturing Company expects from you to calculate and present the master budget…
A: Gross profit = Sales - Cost of goods sold Expected net profit = Gross profit - Operating expenses
Q: 2. Al Nebras Company has budgeted production for next year as follows: 1st Year Q1 Q2 Q3 Q4…
A: Formula: Total production pounds = production units x each unit requires 4 pounds Multiplying…
Q: PROBLEM 5 Isko Corporation has the following budget estimate for the year 2020: Sales P2,800,000…
A: Hi student Since there are multiple questions, we will answer only first question. If you want…
Q: The budgeted sales for the next four quarters are R192 000, R288 000, R288 000 and R336 000…
A: First quarters Second quarters Third quarters Budgeted sales R192,000 R288,000 R288,000…
Q: QUESTION 3 Prepare the Cash Budget for a project of Zao Enterprises for the period 01 June to 31…
A: Cash Budget:- A cash budget is helpful to determine the total cash flows of a firm for a specified…
Q: PROBLEM 10 The controller of Palma Company is examining the following budgeted and actual income…
A: Lets understand the basics. Sales price variance is a variance between the budgeted rate at which…
Q: 11 A retail business budgets for a period with a total sales revenue (operating revenue) of kr…
A: Break even Point: It is the point where total cost of business is equal to total revenue. There…
Q: Landon Inc. projected sales of 31,000 personal journals for 20Y6. The estimated January 1, 20Y6,…
A: Production budget is prepared to estimate the production units and desired inventory for a…
Q: Prepare a cash budget for the first quarter of 2021. Clearly show the amounts for cash sales, credit…
A:
Q: Please solve it ASAP with all requirements Q.7. Toews Ltd has prepared the following flexible budget…
A: A planned cost is a prediction of what a company will spend in the future. To put it another way,…
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Q # 2
The following information has been accumulated by budget department for future sales and production requirements:
Expected Sales for 2010 |
|
||||
Product |
Sales (units) |
Price (Rs.) |
|
Expected Inventories for Jan. 01, 2010 |
Desired Inventories for Dec. 31, 2010 |
X |
30,000 |
50 |
|
10,000 units |
12,000 units |
Y |
50,000 |
60 |
|
15,000 |
20,000 units |
Z |
30,000 |
70 |
|
7,000 |
8,000 units |
Required
- Sales budget in rupees
- Production budget in quantities
Step by step
Solved in 2 steps
- Forecast sales volume and sales budget Sentinel systems Inc. prepared the following sales budget for 20Y8: At the end of December 20Y8, the following unit sales data were reported for the year: Unit Sales Home Alert System Business Alert System United States 1,734 1,078 Europe 609 329 Asia 432 252 For the year ending December 31, 20Y9, unit sales are expected to follow the patterns established during the year ending October 31, 20Y8. The unit selling price for the Home: Alert System is expected to increase to 250, and the unit selling price for the Business Alert System is expected to be increased 820, effective January 1, 20Y9. Instructions 1. Compute the increase or decrease.ase of actual unit sales for the year ended October 31, 20Y8, over budget. Place your answers in a columnar table with the following format: 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y9, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 20Y9. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest unit. 20Y8 Percentage 20Y9 Actual Increase Budgeted Units (Decrease) Units (rounded) 3. Prepare a sales budget for the year ending December 31, 201Y9Forecast sates volume and sales budget For 20Y8, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y8, the following unit sales data were reported for the year: Unit Sales 8" 10" Frame 12" 16" Frame East 8,755 3,686 Central 6,510 3,090 West 12,348 5,616 For the year ending December 31, 20Y9, unit sales are expected to Follow the patterns established during the year ending December 31, 20Y8. The unit selling price for the 8" 10" the frame is expected to Increase to 17 and the unit selling price for the 12" 16" frame is expected to increase to 32, effective January 1, 20Y9. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31,. 20Y8, Over budget. Place your answers in a columnar table with the following format: 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y9, compute the unit sales volume to lie used for preparing the sales budget for the year ending December 31, 20Y9. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest. 20Y8 Percentage 20Y9 Actual Increase Budgeted Units (Decrease) Units (rounded) 3. Prepare a sales budget for the year ending December 51. 20Y9.Budgeted income statement and supporting budgets The budget director of Feathered Friends Inc., with the assistance of thee controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for December: A. Estimated sales for December Bird house....................... 3,200 units at 50 per unit Bird feeder....................... 3,000 units at 70 per unit B. Estimated inventories at December 1: Direct materials Finished products: Wood............ 220 ft Bird house........ 320 units at 27 per unit Plastic............ 240 ft Bird house........ 270 units at 40 per unit C. Desired inventories at December 31: Direct materials Finished products: Wood............ 220 ft Bird house........ 290 units at 27 per unit Plastic............ 200 ft Bird house........ 205 units at 41 per unit D. Direct materials used in production: In manufacture of Bird House: In manufacture of Bird Feeder: Wood............ 0.80 ft. per unit of product Wood........ 1.20 ft. per unit of product Plastic............ 0.50 lb. per unit of product Plastic......... 0.75 lb. per unit of product E. Anticipated cost of purchases and beginning and ending inventory of direct materials: Wood 7.00 per ft Plastic 1.00 per lb. F. Direct labor requirements: Bird House: Fabrication Department...................... 0.20 hr. at 16 per hr. Assembly Department........................ 0.30 hr. at 12 per hr. Bird Feeder: Fabrication Department...................... 0.40 hr. at 16 per hr. Assembly Department........................ 0.35 hr. at 12 pr hr. G. Estimated factory overhead costs for December: Indirect factory wages 75,000 Depreciation of plant and equipment 23,000 Power and light 6,000 Insurance and property tax 5,000 H. Estimated operating expenses for December: Sales salaries expense 70,000 Advertising expense 18,000 Office salaries expense 21,000 Depreciation expenseoffice equipment 600 Telephone expenseselling 550 Telephone expenseadministrative 250 Travel expenseselling 4,000 Office supplies expense 200 Miscellaneous administrative expense 400 I. Estimated other income and expense for December: Interest revenue200 Interest expense122 J. Estimated tax rate: 30% Instructions 1. Prepare a sales budget for December. 2. Prepare a production budget for December. 3. Prepare a direct materials purchases budget for December. 4. Prepare a direct labor cost budget for December. 5. Prepare a factory overhead cost budget for December. 6. Prepare a cost of goods sold budget for December. Work in process at the beginning of December is estimated to be 29,000, and work in process at the end of December is estimated to be 35,400. 7. Prepare a selling and administrative expenses budget for December. 8. Prepare a budgeted income statement for December.
- Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January I, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared by the Accounting Department of Regina Soap Co.: Cash 85,000 Accounts Receivable........................................ 125,600 Finished Goods............................................ 69,300 Work in Process............................................ 32,500 Materials.................................................. 48,900 Prepaid Expenses.......................................... 2,600 Plant and Equipment....................................... 325,000 Accumulated DepreciationPlant and Equipment........... 156,200 Accounts Payable.......................................... 62,000 Common Stock. 10 par.................................... 180,000 Retained Earnings.......................................... 290,700 688,900 688,900 Factory output and sales for 20Y9 are expected to total 200,000 units of product, which are to be sold at 5.00 per unit. The quantities and costs of the inventories at December 31, 20Y9, are expected to remain unchanged from the balances at the beginning of the year. Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows: Estimated Costs and Expenses Fixed Variable (Total for Year) (Per Unit Sold) Cost of goods manufactured and sold: Direct materials.................................. 1.10 Direct labor...................................... 0.65 Factory overhead: Depreciation of plant and equipment........... 40,000 Other factory overhead........................ 12,000 0.40 Selling expenses: Sales salaries and commissions.................... 46,000 0.45 Advertising...................................... 64,000 Miscellaneous selling expense................... 6,000 0 25 Administrative expenses: Office and officers salaries........................ 72,400 0.12 Supplies......................................... 5,000 0.10 Miscellaneous administrative expense............. 4,000 0.05 Balances of accounts receivable, prepaid expenses, anti accounts payable at the end of the year are not expected to differ significantly from the beginning balances. Federal income tax of 30,000 on 20Y9 taxable income will be paid during 20Y9. Regular quarterly cash dividends of 0.15 per share are expected to be declared and paid in March, June. September, and December on 18,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for 75,000 cash in May. Instructions 1. Prepare a budgeted income statement for 20Y9. 2. Prepare a budgeted balance sheet as of December 31, 20Y9, with supporting calculations.Budgeted income statement and supporting budgets The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for March: A. Estimated sales for March: Batting helmet.................. 1,200 units at 40 per unit Football helmet................. 6,500 units at 160 per unit B. Estimated inventories at March 1: Direct materials: Finished products: Plastic............ 90 lbs. Batting helmet....... 40 units at 25 per unit Foam lining....... 80 lbs. Football helmet...... 240 units at 77 per unit C. Desired inventories at March 31: Direct materials: Finished products: Plastic............ 50 lbs. Batting helmet....... 50 units at 25 per unit Foam lining....... 65 lbs. Football helmet...... 220 units at 78 per unit D. Direct materials used in production: In manufacture of batting helmet: Plastic............................... 1.2lbs. per unit of product Foam lining......................... 0.5 lb. per unit of product In manufacture of football helmet: Plastic............................... 3.5lbs. per unit of product Foam lining.......................... 1.5 lbs. per unit of product E. Anticipated cost of purchases and beginning and ending inventory of direct materials: Plastic........................ 6 per lb. Foam lining................... 4 per lb. F. Direct labor requirements Batting helmet: Molding Department............. 0.2 hr. at 20 per unit Assembly Department............ 0.5 hr. at 14 per hr. Football helmet: Molding Department............. 0.5 hr. at 20 per hr. Assembly Department............ 1.8 hrs. at 14 per hr. G. Estimated factory overhead costs for March: Indirect factory wages 86,000 Depreciation of plant and equipment 12,000 Power and light 4,000 Insurance and property tax 2,300 H. Estimated operating expenses for March: Sales salaries expense 184,300 Advertising expense 87,300 Office salaries expense 32,400 Depreciation expenseoffice equipment 3,800 Telephone expenseselling 5,800 Telephone expenseadministrative 1,200 Travel expenseselling 9,000 Office supplies expense 1,100 Miscellaneous administrative expense 1,000 I. Estimated other income and expense for March: Interest revenue 940 Interest expense 872 J. Estimated tax rate:30% Instructions 1. Prepare a sales budget for March. 2. Prepare a production budget for March. 3. Prepare a direct materials purchases budget for March. 4. Prepare a direct labor cost budget for March. 5. Prepare a factory overhead cost budget for March. 6. Prepare a cost of goods sold budget for March. Work in process at the beginning of March is estimated to be 15,300, and work in process at the end of March is desired to be 14,800. 7. Prepare a selling and administrative expenses budget for March. 8. Prepare a budgeted income statement for March.Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y9, the following tentative trial balance as of December 31, 20Y8, is prepared by the Accounting Department of Mesa Publishing Co.: Cash. 26,000 Finished Goods.............................................. 16,900 Work in Process.............................................. 4,200 Materials.................................................... 6,400 Prepaid Expenses............................................ 600 Plant and Equipment......................................... 82,000 Accumulated DepreciationPlant and Equipment............. 32,000 Accounts Payable............................................ 14,800 Common Stock. 1.50 par..................................... 30,000 Retained Earnings............................................ 83,100 159,900 159,900 Factory output and sales for 20Y9 are expected to total 3,800 units of product, which are to be sold at 120 per unit. The quantities and costs of the inventories at December 31, 20Y9, are expected to remain unchanged from the balances at the beginning of the year. Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows: Estimated Costs and Expenses Fixed Variable (Total for Year) (Per Unit Sold) Cost of goods manufactured and sold: Direct materials................................... 30.00 Direct labor....................................... 840 Factory overhead: Depreciation of plant and equipment............ 4,000 Other factory overhead......................... 1,400 4.80 Selling expenses: Sales salaries and commissions..................... 12,800 13.50 Advertising....................................... 13,200 Miscellaneous selling expense..................... 1,000 2.50 Administrative expenses: Office and officers salaries......................... 7,800 7.00 Supplies.......................................... 500 1.20 Miscellaneous administrative expense.............. 400 2.40 Balances of accounts receivable, prepaid expenses, and accounts payable at the end of the year are not expected to differ significantly from the beginning balances, federal income tax of 35,000 on 20Y9 taxable income will be paid during 20Y9. Regular quarterly cash dividends of 0.20 per share are expected to be declared and paid in March, June, September, and December on 20,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for 22,000 cash in May. Instructions 1. Prepare a budgeted income statement for 20Y9. 2. Prepare a budgeted balance sheet as of December 31, 20Y9, with supporting calculations.
- Forecast sales volume and sales budget Sentinel Systems Inc. prepared the following sales budget for 20Y8: Sentinel Systems Inc. Sales Budget For the Year Ending December 31, 20 Y8 Unit Sales Unit Selling Total Product and Area Volume Price Sales Home Alert System: United States 1,700 200 340,000 Europe 580 200 116,000 Asia 450 200 90,000 Total 2,730 546,000 Business Alert System: United States 980 750 735,000 Europe 350 750 262,500 Asia 240 750 180,000 Total 1,570 1,177,500 Total revenue from sales 1,723,500 At the end of December 20Y8, the following unit sales data were reported for the year: Unit Sales Home Alert System Business Alert System United States 1,734 1,078 Europe 609 329 Asia 432 252 For the year ending December 31, 20Y9, unit sales are expected to follow the patterns established during the year ending December 31, 20Y8. The unit selling price for the Home Alert System is expected to increase to 250, and the unit selling price for the Business Alert System is expected to be decreased to 820, effective January 1, 20Y9. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y8, over budget. Place your answers in a columnar table with the following format: Unit Sales, Year Ended 20Y8 Increase (Decrease) Actual Over Budget Budget Actual Sales Amount Percent Home Alert System: United States Europe Asia Business Alert System: United States Europe Asia 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y9, compute the unit sales volume to lie used for preparing the sales budget for the year ending December 31, 20Y9- Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest unit. 20Y8 Actual Units Percentage Increase (Decrease) 20Y9 Budgeted Units (rounded) 3. Prepare a sales budget for the year ending December 31, 20Y9.Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 20Y8, the following tentative trial balance as of December 31, 20Y7, is prepared by the Accounting Department of Mesa Publishing Co.: Cash 26,000 Accounts Receivable 23,800 Finished Goods 16,900 Work in Process 4,200 Materials 6,400 Prepaid Expenses 600 Plant and Equipment 82.000 Accumulated DepreciationPlant and Equipment 32,000 Accounts Payable 14.800 Common Stock. 1.50 par 30,000 Retained Earnings 83,100 159,900 159,900 Factory output and sales for 20Y8 are expected to total 3,800 units of product, which are to be sold at 120 per unit. The quantities and costs of the inventories at December 31, 20Y8, are expected to remain unchanged from the balances at the beginning of the year. Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows: Estimated Costs and Expenses Fixed Variable (Total for Year) (Per Unit Sold) Cost of goods manufactured and sold: Direct materials 30.00 Direct labor B.40 Factory overhead: Depreciation of plant and equipment 4,000 Other factory overhead 1,400 4.30 Selling expenses: Sales salaries and commissions 12,800 13.50 Advertising 13,200 Miscellaneous selling expense 1,000 2.50 Administrative expenses: Office and officers salaries 7,800 7.00 Supplies 500 1.20 Miscellaneous administrative expense 400 2.40 Balances of accounts receivable, prepaid expenses, and accounts payable at the end of the year are not expected to differ significantly from the beginning balances. Federal income tax of 35,000 on 20Y8 taxable income will be paid during 20Y8. Regular quarterly cash dividends of 0.20 per share are expected to be declared and paid in March, June, September, and December on 20,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for 22,000 cash in May. Instructions 1. Prepare a budgeted income statement for 20Y8. 2. Prepare a budgeted balance sheet as of December 31,20Y8, with supporting calculations.Budgeted income statement and balance sheet As a preliminary to requesting budget estimates of sales, costs, and expenses for the fiscal year beginning January 1, 2017, the following tentative trial balance as of December 31, 2016, is prepared by the Accounting Department of Regina Soap Co.: Cash............................................................. 85,000 Accounts Receivable............................................... 125,600 Finished Goods................................................... 69,300 Work in Process................................................... 32,500 Materials......................................................... 48,900 Prepaid Expenses................................................. 2,600 Plant and Equipment.............................................. 325,000 Accumulated Depreciation Plant and Equipment.................. 156,200 Accounts Payable................................................. 62,000 Common Stock, 10 par........................................... 180,000 Retained Earnings................................................. 290,700 688,900 688,900 Factory output and sales for 2017 are expected to total 200,000 units of product, which are to be sold at 5.00 per unit. The quantities and costs of the inventories at December 31, 2017, are expected to remain unchanged from the balances at The beginning of the year. Budget estimates of manufacturing costs and operating expenses for the year are summarized as follows: Estimated Costs and Expenses Cost of goods manufactured and sold: Fixed (Total for Year) Direct materials................................................ 1.10 Direct labor.................................................... 0.65 Factory overhead: Depreciation of plant and equipment.......................... 40,000 Other factory overhead....................................... 12,000 0.40 Selling expenses: Sales salaries and commissions.................................. 46,000 0.45 Advertising.................................................... 64,000 Miscellaneous selling expense.................................. 6,000 0.25 Administrative expenses: Office and officers salaries...................................... 72,400 0.12 Supplies....................................................... 5,000 0.10 Miscellaneous administrative expense........................... 4,000 0.05 Balances, of accounts receivable, prepaid expenses, and accounts payable at the end of the year are not expected to differ significantly from the beginning balances. Federal income tax of 30,000 on 2017 taxable income will be paid during 2017. Regular quarterly cash dividends of 0.15 per share are expected to be declared and paid in March, June, September, and December on 18,000 shares of common stock outstanding. It is anticipated that fixed assets will be purchased for 75,000 cash in May. Instructions 1. Prepare a budgeted income statement for 2017. 2. Prepare a budgeted balance sheet as of December 31, 2017, with supporting calculations.
- Forecast sales volume and sales budget For 2016, Raphael Frame Company prepared the .sales budget that follows. At the end of December 2016, the following unit sales data were reported for the year. Unit Sales 8" 10" Frame 12" 16" Frame East 8,755 3,686 Central 6,510 3,090 West 12,348 5,616 For the year ending December 31, 2017, unit sales are expected to follow die patterns established during the year ending December 31, 2016. The unit selling price for the 8" 10" frame is expected to increase to 17 and die unit selling price for die 12" 16" frame is expected to increase to 32, effective January 1, 2017. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 2016, over budget. Place your answers in a columnar table with the following format: Unit Sales, Year Ended 2016 Increase (Decrease) Actual Over Budget Budget Actual Sales Amount Percent 8" 10" Frame: East Central West 12" 16" Frame: East Central West 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 2017, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 2017. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest unit. 2016 Actual Units Percentage Increase (Decrease) 2017 Budgeted Units (rounded) 3. Prepare a sales budget for the year ending December 31, 2017.Forecast sales volume and sales budget Sentinel Systems Inc. prepared the following sales budget for 2016: At the end of December 2016, the following unit sales data were reported for the year: For the year ending December 31 , 2017, unit sales are expected to follow the patterns established during the year ending December 31, 2016. The unit selling price for the Home Alert System is expected to increase to 250, and the unit selling price for the Business Alert System is expected to be decreased to 820, effective January 1, 2017. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 2016, over budget. Place your answers in a columnar table with the following format: 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 2017, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 2017. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest unit. 3. Prepare a sales budget for the year ending December 31, 2017.Forecast sales volume and sales budget For 20Y6, Raphael Frame Company prepared the sales budget that follows. At the end of December 20Y6, the following unit sales data were reported for the year: Unit Sales 8" 10" Frame 12" 16" Frame East 8,755 3,686 Central 6,510 3,090 West 12,348 5,616 Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y6 Unit Sales Unit Selling Total Product and Area Volume Price Sales 8"10" Frame: East 8,500 16 136,000 Central 6,200 16 99,200 West 12,600 16 201,600 Total 27,300 436,800 12" x 16" Frame: East 3,800 30 5114,000 Central 3,000 30 90,000 West 5,400 30 162,000 Total 12,200 366,000 Total revenue from sales 802,800 For the year ending December 31, 20Y7, unit sales are expected to follow the patterns established during the year ending December 31, 20Y6. The unit selling price for the 8" 10"frame is expected to increase to 17, and the unit selling price for the 12" 16" frame is expected to increase to 32, effective January 1, 20Y7. Instructions 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 20Y6, over budget. Place your answers in a columnar table with the following format: Unit Sales, Year Ended 20Y6 Increase (Decrease) Actual Over Budget Budget Actual Sales Amount Percent 8" 10" Frame: East Central West 12"16" Frame: East Central West 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 20Y7, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 20Y7. Place your answers in a columnar table similar to that in part (1) but with the following column heads. Round budgeted units to the nearest unit. 20Y6 Percentage 20Y7 Actual Increase Budgeted Units (Decrease! Units (rounded) 3. Prepare a sales budget for the year ending December 31, 20Y7.