ROBLEM lling in for his supervisor, who suddenly left the company, Harvey quickly valuated the situation to wrap up his department's production budget. The epartment currently holds enough inventory to be in compliance with its andard which is based on the following month's budgeted sales. From the les and previous budgets, he learned the budgeted unit sales for the next 4 onths and the standard for holding inventory at month end which are both resented here. Unit sales per month Month 1 Month 2 Month 3 Month 4 Ending inventory standard Materials held at month end 5,000 4,500 6,000 6,500 10% Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Show the production budget that Harvey would assemble for the next quarter. Budgeted sales volume Target ending FG Inventory Total units needed Beginning FG Inventory Budgeted units to be produced. Month 1 ▼ ▼ Month 2 ▼ Month 3 ▼ ▼ Quarter ▼ ▼

ROBLEM lling in for his supervisor, who suddenly left the company, Harvey quickly valuated the situation to wrap up his department's production budget. The epartment currently holds enough inventory to be in compliance with its andard which is based on the following month's budgeted sales. From the les and previous budgets, he learned the budgeted unit sales for the next 4 onths and the standard for holding inventory at month end which are both resented here. Unit sales per month Month 1 Month 2 Month 3 Month 4 Ending inventory standard Materials held at month end 5,000 4,500 6,000 6,500 10% Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Show the production budget that Harvey would assemble for the next quarter. Budgeted sales volume Target ending FG Inventory Total units needed Beginning FG Inventory Budgeted units to be produced. Month 1 ▼ ▼ Month 2 ▼ Month 3 ▼ ▼ Quarter ▼ ▼

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter4: Financial Planning And Forecasting

Section: Chapter Questions

Problem 5P

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.
Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?
Norton Company, a manufacturer of infant furniture and carriages, is in the initial stages of preparing the annual budget for the coming year. Scott Ford has recently joined Nortons accounting staff and is interested in learning as much as possible about the companys budgeting process. During a recent lunch with Marge Atkins, sales manager, and Pete Granger, production manager, Ford initiated the following conversation. FORD: Since Im new around here and am going to be involved with the preparation of the annual budget, Id be interested in learning how the two of you estimate sales and production numbers. ATKINS: We start out very methodically by looking at recent history, discussing what we know about current accounts, potential customers, and the general state of consumer spending. Then, we add that usual dose of intuition to come up with the best forecast we can. GRANGER: I usually take the sales projections as the basis for my projections. Of course, we have to make an estimate of what this years closing inventories will be, which is sometimes difficult. FORD: Why does that present a problem? There must have been an estimate of closing inventories in the budget for the current year. GRANGER: Those numbers arent always reliable since Marge makes some adjustments to the sales numbers before passing them on to me. FORD: What kind of adjustments? ATKINS: Well, we dont want to fall short of the sales projections so we generally give ourselves a little breathing room by lowering the initial sales projection anywhere from 5 to 10 percent. GRANGER: So, you can see why this years budget is not a very reliable starting point. We always have to adjust the projected production rates as the year progresses, and of course, this changes the ending inventory estimates. By the way, we make similar adjustments to expenses by adding at least 10 percent to the estimates; I think everyone around here does the same thing. Required: 1. Marge Atkins and Pete Granger have described the use of budgetary slack. a. Explain why Atkins and Granger behave in this manner, and describe the benefits they expect to realize from the use of budgetary slack. b. Explain how the use of budgetary slack can adversely affect Atkins and Granger. 2. As a management accountant, Scott Ford believes that the behavior described by Marge Atkins and Pete Granger may be unethical and that he may have an obligation not to support this behavior. By citing the specific standards of competence, confidentiality, integrity, and/or credibility from the Statement of Ethical Professional Practice (in Chapter 1), explain why the use of budgetary slack may be unethical. (CMA adapted)
Munoz Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Munoz's policy is to maintain an ending inventory balance equal to 10 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $75,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter. Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget Budgeted cost of goods sold Plus: Desired ending inventory Inventory needed Less: Beginning inventory Required purchases (on account) January February $ 57,000 $…
You have been recently hired as general manager of Lucky’s. It is September 1, and you must prepare the operating budget of this establishment for the first quarter of the upcoming calendar year, and submit it to the corporate office. Since you have been at the operation for only a month or so, you must rely solely on historical data. You gather sales reports and records for the months of January through August of the current year. Using the data and the budget worksheet provided, prepare the operating budget for Lucky’s for the months of January through March of the upcoming year. Here is the information you determined from the most recent sales and costs records (Please note that the first month has already been completed): Sales are 10 percent higher than those of the same month during the previous year. Food cost percentage is steady at 32 percent. Fixed labor costs are steady at $9,000 per month. Variable labor costs are 15 percent of sales. Occupancy costs will remain steady…
Help me
Rooney Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Rooney's policy is to maintain an ending inventory balance equal to 10 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $77,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter.
Regal Furnitures produces and sells high-quality reading tables. One of the very popular models in the reading table lineup is RT360. The management accountant of the company is in the process of preparing its Selling and Administrative Expense Budget for the first quarter of the year. The following budget data are available: Assume that all of these expenses (except depreciation) are paid in cash in the month they are incurred. Answer the following questions:a) If Regal Furnitures has budgeted to sell 19,000 RT360 tables in January, then what will be the total budgeted selling and administrative expenses for January?b) If the company has budgeted to sell 16,000 RT360 tables in February, then what will be the budgeted total cash disbursements for selling and administrative expenses for February?c) If the budgeted total cash disbursements for selling and administrative expenses for March total Tk. 459,200, then how many RT360 table does the company plan to sell in March?
Rooney Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Rooney's policy is to maintain an ending inventory balance equal to 10 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $83,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter. Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget January February March Budgeted cost of goods sold $ 53,000 $ 57,000 $ 63,000 Plus: Desired ending inventory 5,700 Inventory needed Less: Beginning inventory…
Rooney Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Rooney's policy is to maintain an ending inventory balance equal to 15 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $82,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter. Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget January $ Budgeted cost of goods sold Plus: Desired beginning inventory Inventory needed Less: Desired beginning inventory Required purchases (on account) $…
Franklin Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Franklin's policy is to maintain an ending inventory balance equal to 10 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $79,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter. Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget January February March Budgeted cost of goods sold $ 56,000 $ 60,000 $ 66,000 Plus: Desired ending inventory 6,000 Inventory needed 62,000 Less: Beginning…
Thornton Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Thornton's policy is to maintain an ending inventory balance equal to 15 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $84,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter. Complete this question by entering your answers in the tabs below. Req A Req B and C Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget January February March Budgeted cost of goods sold $ 59,000 $ 63,000 $ 69,000 Plus: Desired ending inventory 9,450 Inventory needed 68,450 Less: Beginning…