Ch. 8 Homework Budgeted Total Sales/Budgeted Production Please solve and explain the answers to the following problem Shadee Corp. expects to sell 600 sun visors in May and 800 in June. Each visor sells for $18. Shadee’s beginning and ending finished goods inventories for May are 75 and 50 units, respectively. Ending finished goods inventory for June will be 60 units. 1) 1. Determine Shadee's budgeted total sales for May and June. 2) Determine Shadee's budgeted production in units for May and June.
Q: PROBLEM 7-C PURCHASES BUDGET The following are budgeted data for the Emerald Company, a…
A: Budgets is the expected amount that is based on expected sales amount. In this question, the desired…
Q: Q.Production budget. Superior Industries sales budget shows quarterly sales for the next year as…
A: Production budget: Production budget is the estimation or projection of number of units the company…
Q: Problem 8-24 (Static) Cash Budget with Supporting Schedules [LO8-2, LO8-4, LO8-8] Garden Sales,…
A:
Q: PROBLEM 7-I CASH BUDGET The Francine Company, a merchandising firm, has planned the following sales…
A: Cash budget:- A cash budget is considered as the estimation of cash inflows and outflows of a…
Q: Problem 6 (Flexible Budget) Factory Overhead Flexible Budget Preparation Summary flexible overhead…
A: Flexible budgets are those estimates or forecasts that is made for future period of time and these…
Q: or the Sleepeze, 12,340 for the Plushette, and 4,620 for the Ultima. Gene Dixon, vice president of…
A: Activity-based budget refers to the budget which collects, documents, and evaluates the business…
Q: X Company needs a cash budget for the month of May. The following is available: a. Cash balance on…
A: Cash budget is the budget which includes the estimation of cash to be used for payments and…
Q: QUESTION 48 Pasta Disasta, Inc. is preparing its master budget for its first quarter of business. It…
A: The budgeted purchases are based on the estimates. The budgeted purchases can be determined by…
Q: 1. Question : (TCO 7) The culmination of preparing operating budgets is the: pro forma balance…
A: Hey, since there are multiple questions posted, we will answer first question. If you want any…
Q: budgeted production (in units)
A: We know that Closing inventory can be obtained using the formula below Closing inventory = Opening…
Q: No.2 The Medvedev Company, a merchandising firm, has planned the following sales for the next four…
A: Schedule of cash receipts shows how much amount is expected to be received from customers from…
Q: PROBLEM 7-C_PURCHASES BUDGET The following, are budgeted data for the Emeratd Company, a…
A: Cost of goods sold:- Cost of goods sold includes all the direct costs that are related to production…
Q: Seaworthy Company, a merchandising company, has prepared the following sales budget: Month…
A: Sales budget is prepared by the management of the company to forecast the sales for the upcoming…
Q: Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second…
A: 1.
Q: Cathy’s Cookies produces cookies for resale at local grocery stores. The company is currently in the…
A: Sales (units) for the quarter = Prior year quarterly sales + 20% increase
Q: The direct labor budget of Kiko Corporation for the upcoming fiscal year contains the following…
A: The manufacturing overhead rate based on the direct labor hour is calculated by dividing the total…
Q: , and sales manager, has gathered the following data for use in developing the budgeted income…
A: Answer 3)
Q: PROBLEM 02: Production and Direct material Budget Tonga Toys manufactures and distributes a number…
A: A budget is a financial plan which is associated with future. It could be prepared for the…
Q: Problem 4 Oui-Got Stuff is preparing its budget for the coming year. Below is information about the…
A: Budgeting: It is a process of planning the work to be performed. Under this process a formal plan is…
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: Problem 22-7AA Merchandising: Preparation and analysis of cash budgets with supporting inventory and…
A: Note: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question…
Q: Holland Limited makes all purchases on account, subject to the following budgeted payment pattern:…
A: Budgeted accounts payable as on March 31 includes the purchases on account that have been made till…
Q: Nina Company prepared the following fixed budget for July using 7,640 units for budgeted sales.…
A: Variances shows the difference or variation between the budgeted and the actual amounts. If the…
Q: Activity 3 The actual information pertains to the month of August. As part of the budgeting process…
A: Sales revenue (Flexible budget)=Static sales revenueUnits (Static)×Actual…
Q: 1. Using the president’s new assumptions in (a) above, prepare a schedule of expected cash…
A: Solution: Introduction: Since as per the BNED policy, each question is answered to a maximum of…
Q: What is the amount of Accounts Receivable as of September 30th
A: Cash budget: Cash budget is a budget prepared by the company for analysing the future cash receipts…
Q: Prepare a cash budget for two months. P10.50B (LO 4) Nigh Company prepares monthly cash budgets.…
A: Budgets are prepared in order to predict the financial outcomes of the upcoming transactions. Cash…
Q: LL %24 Requlred Informotlon The following information applies to the questions displayed below.]…
A: 1. Cost of Goods Sold - The cost of goods sold is the cost incurred to sell the goods. 2. Ending…
Q: e. Required: Using the new assumptions described above, complete the following requirements: 1.
A: Disclaimer: “Since you have posted a question with multiple sub-parts, we will solve first three…
Q: PART A: Use the following information to prepare a budgeted balance sheet for Grover Company for…
A: The budgeted Balance sheet is a balance sheet prepared on management budgets. Please find the…
Q: Exercise 5 (Manufacturing Overhead Budget) The direct labor budget of Kiko Corporation for the…
A: Manufacturing overhead budget in the business shows total indirect costs incurred in production and…
Q: % in the month of sale and 40% in the month following the sale. 3. The company pays for 50% of its…
A: A cash disbursement is a financial outflow made in exchange for goods or services. To reimburse a…
Q: Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second…
A: The cash budget indicates the estimation of cash and cash equivalent transactions assumed by the…
Q: Problem 5 Prepare a cash budget by month for the month quarter ending September 30, 2009, from the…
A: Cash Budget refers to Future Estimation of Expected cash receipts and Payments to be incurred during…
Q: QUESTION 4 Pasta Disasta, Inc. is preparing its master budget for its first month of business. It…
A: Budgeted purchase for 1st month = Sales units in 1st month + Ending inventory = 1000 units + 100…
Q: Big Construction's actual results and the Master or Static budget information for the month of May…
A: In this question, we are required to calculate operating profit in flexible budget. Flexible budget…
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 Bates & Hill's direct materials purchases budget for the first quarter. (Enter price per…
A: Solution:- Calculation of Bates & Hill's direct materials purchases budget for the first quarter…
Q: Problem 8-30 (Static) Integration of the Sales, Production, and Direct Materials Budgets [LO8-2,…
A: “Since you have asked multiple sub-parts, we will solve the first three sub-parts for you. If you…
Q: Soft Glow Candle Inc. projected sales of 96,000 candles for 20Y4. The estimated January 1, 20Y4,…
A: Budgeted production = Budgeted sales + Desired ending inventory - beginning inventory
Q: Production Budget Quincy Inc. projected sales of 62,000 personal journals for 20Y6. The estimated…
A: Calculate the budgeted production for 20Y6
Q: Daybook Inc. budgeted production of 403,500 personal journals in 20Y6. Each journal requires…
A: Total budgeted time required for production = Budgeted production x Time required for each journal…
Variance Analysis
In layman's terms, variance analysis is an analysis of a difference between planned and actual behavior. Variance analysis is mainly used by the companies to maintain a control over a business. After analyzing differences, companies find the reasons for the variance so that the necessary steps should be taken to correct that variance.
Standard Costing
The standard cost system is the expected cost per unit product manufactured and it helps in estimating the deviations and controlling them as well as fixing the selling price of the product. For example, it helps to plan the cost for the coming year on the various expenses.
Ch. 8 Homework Budgeted Total Sales/Budgeted Production
Please solve and explain the answers to the following problem
Shadee Corp. expects to sell 600 sun visors in May and 800 in June. Each visor sells for $18. Shadee’s beginning and ending finished goods inventories for May are 75 and 50 units, respectively. Ending finished goods inventory for June will be 60 units.
1) 1. Determine Shadee's budgeted total sales for May and June.
2) Determine Shadee's budgeted production in units for May and June.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
- Budgeted income statement and supporting budgets The, budget director of Feathered Friends Inc., 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 December 2016: 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 200 ft Bird house....... 320 units at 27 per unit Plastic 240 lbs. Bird feeder....... 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 lbs. Bird feeder....... 250 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 050 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 per hr. g. Estimated factory overhead costs for December. Indirect factory wages 75,000 Power and light 6,000 Depreciation of plant and equipment 23,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 revenue 200 Interest expense 122 j. Estimated lax 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.Forecast 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 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 lb. Batting helmet 40 units at 25 per unit Foam lining 80 lb. Football helmet 240 units at 77 per unit c. Desired inventories at March 31: Direct materials: Finished products: Plastic 50 lb. Batting helmet 50 units at 25 per unit Foam lining 65 lb. Football helmet 220 its at 78 per unit d. Direct materials used in production: In manufacture of batting helmet: Plastic 1.20 lb. per unit of product Foam lining 0.50 lb. per unit of product In manufacture of football helmet: Plastic 3.50 lb. per unit of product Foam lining 1.50lb. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Plastic 6.00 per lb. Foam lining 4.00 per lb. f. Direct labor requirements: Batting helmet: Molding Department 0.20 hr. at 20 per hr. Assembly Department 0.50 hr. at 14 per hr. Football helmet: Molding Department 0.50 hr. at 20 per hr. Assembly Department l.80 hrs.at 14perhr. g. Estimated factory overhead costs for March: Indirect factory wages 86,000 Power and light 4,000 Depreciation of plant and equipment 12,000 Insurance and property tax 2300 h. Estimated operating for March: Sales salaries expense 184,300 Advertising expense 87,200 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. 9.Prepare a factory overhead cost budget for March. 10.Prepare a cost of goods .sold budget for March. Work in process at the beginning of March is estimated to the 115,300, and work in process at the end of March is desired to be 14,800. 11.Prepare a selling and administrative expenses budget for March. 12.Prepare a budgeted income statement for March.Budgeted income statement and supporting budgets The budget director of Birds of a Feather Inc., 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 January: a. Estimated sales for January: Birdhouse 6.000 units at 55 per unit Bird feeder 4,500 units at 75 per unit b. Estimated inventories at January 1: Direct materials: Finished products: Wood 220 ft. Birdhouse 300 units at 23 per unit Plastic 250 lb. Bird feeder 240 units at 34 per unit c. Desired inventories at January 31: Direct materials: Finished products: Wood 180 ft. Birdhouse 340 units at 23 per unit Plastic 210 lb. Bird feeder 200 units at 34 per unit d. Direct materials used in production: In manufacture of Birdhouse: In manufacture of Bird Feeder: Wood ... 0.80 ft. per unit of product Wood 1.20 ft. per unitof 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 8.00 per ft. Plastic 1.20 per lb. f. f. Direct labor requirements: Birdhouse: Fabrication Department 0.20 hr. at15 per hr. Assembly Department 0.30 hr. at 12 per hr. Bird Feeder: Fabrication Department 0.40 hr. at15 per hr. Assembly Department 0.35 hr. at 12 per hr. g. Estimated factory overhead costs for January: Indirect factory wages 80,000 Power and light 8,000 Depreciation of plant and equipment 25,000 Insurance and property tax 2,000 h. Estimated operating expenses for January: Sales salaries expense 90,000 Advertising expense 20,000 Office salaries expense 18,000 Depredation expenseoffice equipment 800 Telephone expenseselling 500 Telephone expenseadministrative 200 Travel expenseselling 5,000 Office supplies expense 250 Miscellaneous administrative expense 450 i. Estimated other income and expense for January: Interest revenue 300 Interest expense 224 j. Estimated tax rate: 30% Instructions 1. Prepare a sales budget for January. 2. Prepare a production budget for January. 3. Prepare a direct materials purchases budget for January. 4. Prepare a direct labor cost budget for January. 5. Prepare a factory overhead cost budget for January. 6. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be 29,000, and work in process at the end of January is estimated to be 35,400. 7. Prepare a selling and administrative expenses budget for January. 8. Prepare a budgeted income statement for January.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 2016: 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: Plastic50 lbs. Batting helmet......... 50 units at 25 per unit Foam lining65 lbs. Football helmet........ 220 units at 78 per unit d. Direct materials used in production: In manufacture of batting helmet: Plastic 1.20 lbs. per unit of product Foam lining 0.50 lb. per unit of product In manufacture of football helmet: Plastic 3.50 lbs. per unit of product Foam lining 1.50 lbs. per unit of product e. Anticipated cost of purchases and beginning and ending inventor) of direct materials: Plastic 6.00 per lb. Foam lining 4.00 per lb. f. Direct labor requirements: Batting helmet: Molding Department 0.20 hr. at 20 per hr. Assembly Department 0.50 hr. at 14 per hr. Football helmet: Molding Department 0.50 hr. at 20 per hr. Assembly Department 1.80 hrs. at 14 per hr. g. Estimated factory overhead costs for March: Indirect factory wages 86,000 Power and light 4,000 Depreciation of plant and equipment 12,000 Insurance and property tax 2,300 h. Estimated operating expenses for March: Sales salaries expense 184,300 Advertising expense 87,200 Office salaries expense 32,400 Depreciation expenseoffice equipment 3,800 Telephone expenseselling 5,800 Telephone expenseadministrative 1,200 Travel expense-selling 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 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 lb. Batting helmet 40 units at 25 per unit Foam lining 80 lb. Football helmet 240 units at 77 per unit c. Desired inventories at March 31: Direct materials: Finished products: Plastic 50 lb. Batting helmet 50 units at 25 per unit Foam lining 65 lb. Football helmet 220 its at 78 per unit d. Direct materials used in production: In manufacture of batting helmet: Plastic 1.20 lb. per unit of product Foam lining 0.50 lb. per unit of product In manufacture of football helmet: Plastic 3.50 lb. per unit of product Foam lining 1.50lb. per unit of product e. Anticipated cost of purchases and beginning and ending inventory of direct materials: Plastic 6.00 per lb. Foam lining 4.00 per lb. f. Direct labor requirements: Batting helmet: Molding Department 0.20 hr. at 20 per hr. Assembly Department 0.50 hr. at 14 per hr. Football helmet: Molding Department 0.50 hr. at 20 per hr. Assembly Department l.80 hrs.at 14perhr. g. Estimated factory overhead costs for March: Indirect factory wages 86,000 Power and light 4,000 Depreciation of plant and equipment 12,000 Insurance and property tax 2300 h. Estimated operating for March: Sales salaries expense 184,300 Advertising expense 87,200 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. 9.Prepare a factory overhead cost budget for March. 10.Prepare a cost of goods .sold budget for March. Work in process at the beginning of March is estimated to the 115,300, and work in process at the end of March is desired to be 14,800. 11.Prepare a selling and administrative expenses budget for March. 12.Prepare a budgeted income statement for March.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, 201Y9CASH BUDGETING Rework problem 15-10 using a spreadsheet model. After completing parts a through d, respond to the following: If Bowers customers began to pay late, collections would slow down, thus increasing the required loan amount. If sales dedined, this also would have an effect on the required loan. Do a sensitivity analysis that shows the effects of these two factors on the maximum loan requirement. 15-10 CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2016 and 2017. May 2016 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2017 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale. 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2016 90,000 June 90,000 July 126,000 August 882,000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depredation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2016. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if ail financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain. e. f. g. h.
- Sales, production, direct materials purchases, and direct labor cost budgets The budget director of Gourmet Grill Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning sales and production for July is summarized as follows: A. Estimated sales for July by sales territory: Maine: Backyard Chef............................. 310 units at 700 per unit Master Chef............................... 150 units at 1,200 per unit Vermont: Backyard Chef............................. 240 units at 750 per unit Master Chef............................... 110 units at 1,300 per unit New Hampshire: Backyard Chef............................. 360 units at 750 per unit Master Chef............................... 180 units at 1,400 per unit B. Estimated inventories at July 1: Direct materials: Finished products: Grates..................... 290 units Backyard Chef........ 30 units Stainless steel.............. 1,500 lbs. Master Chef........... 42 units Burner subassemblies...... 170 units Shelves.................... 340 units C. Desired inventories at July 31: Direct materials: Finished products: Grates......................... 340 units Backyard Chef........ 40 units Stainless steel.................. 1,800 lbs. Master Chef........... 20 units Burner subassemblies.......... 155 units Shelves........................ 315 units D. Desired materials used in production In manufacture of Backyard Chef: Grates........................................ 3 units per unit of product Stainless steel................................. 24 lbs. per unit of product Burner subassemblies......................... 2 units per unit of product Shelves....................................... 4 units per unit of product In manufacture of Master Chef: Grates........................................ 6 units per unit of product Stainless steel................................. 42 lbs. per unit of product Burner subassemblies......................... 4 units per unit of product Shelves....................................... 5 units per unit of product E. Anticipated purchase price for direct materials: Grates................. 15 per unit Stainless steel.......... 6 per lb. Burner subassemblies...... 110 per unit Shelves.................... 10 per unit F. Desired labor requirements: Backyard Chef: Stamping Department...................... 0.50 hr. at 17 per hr. Forming Department....................... 0.60 hr. at 15 per hr. Assembly Department...................... 1.00 hr. at 14 per hr. Master Chef: Stamping Department...................... 0.60 hr. at 17 per hr. Forming Department....................... 0.80 hr. at 15 pr hr. Assembly Department...................... 1.50 hrs. at 14 per hr. Instructions 1. Prepare a sales budget for July. 2. Prepare a production budget for July. 3. Prepare a direct materials purchases budget for July. 4. Prepare a direct labor cost budget for July.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.
