7E Budgeting Exercises Business LibreTexts

Januari 24, 2023Januari 25, 2023 falma.u99 budgeting, business, exercises, libretexts

Multiple Choice
1. Which of the following is not a part of budgeting? 1. planning . finding bottlenecks . providing performance evaluations . preventing net operating losses

Answer: d

1. Which of the following is an operating budget? 1. cash budget . production budget . tax budget . capital budget

2. Which of the following is a finance budget? 1. cash budget . production budget . direct materials purchasing budget . tax budget

Answer: a

1. Which approach is most likely to result in employee buy-in to the budget? 1. top-down approach . bottom-up approach . total participation approach . basing the budget on the prior year

2. Which approach requires management to justify all its expenditures? 1. bottom-up approach . zero-based budgeting . master budgeting . capital allocation budgeting

Answer: b

1. Which of the following is true in a bottom-up budgeting approach? 1. Every expense needs to be justified. . Supervisors tell departments their budget amount and the departments are free to work within those amounts. . Departments budget their needs however they see fit. . Departments determine their needs and relate them to the overall goals.

2. The most common budget is prepared for a ________.

Answer: d

1. Which of the operating budgets is prepared first? 1. production budget . sales budget . cash received budget . cash payments budget

2. The direct materials budget is prepared using which budget’s information? 1. cash payments budget . cash receipts budget . production budget . raw materials budget

Answer: c

1. Which of the following is not an operating budget? 1. sales budget . production budget . direct labor budget . cash budget

2. Which of the following statements is not correct? 1. The sales budget is computed by multiplying estimated sales by the sales price. . The production budget begins with the sales estimated for each period. . The direct materials budget begins with the sales estimated for each period. . The sales budget is typically the first budget prepared.

Answer: c

1. The units required in production each period are computed by which of the following methods? 1. adding budgeted sales to the desired ending inventory and subtracting beginning inventory . adding beginning inventory, budgeted sales, and desired ending inventory . adding beginning inventory to budgeted sales and subtracting desired ending inventory . adding budgeted sales to the beginning inventory and subtracting the desired ending inventory.

2. The cash budget is part of which category of budgets? 1. sales budget . cash payments budget . finance budget . operating budget

Answer: c

1. Which is not a section of the cash budget? 1. cash receipts . cash disbursements . allowance for uncollectible accounts . financing needs

2. Which budget is the starting point in preparing financial budgets? 1. the budgeted income statement . the budgeted balance sheet . the capital expense budget . the cash receipts budget

Answer: a

1. Which of the following includes only financial budgets? 1. capital asset budget, budgeted income statement, sales budget . production budget, capital asset budget, budgeted balance sheet . cash budget, budgeted balance sheet, capital asset budget . budgeted income statement, direct material purchases budget, cash budget

2. Which budget evaluates the results of operations at the actual level of activity? 1. capital budget . cash budget . flexible budget . static budget

Answer: c

1. What is the main difference between static and flexible budgets? 1. The fixed manufacturing overhead is adjusted for units sold in the flexible budget. . The variable manufacturing overhead is adjusted in the static budget. . There is no difference between the budgets. . The variable costs are adjusted in a flexible budget.

Questions
1. What is a budget and what are the different types of budgets?

Answer: A budget is a written financial plan for a set period, which is typically a year. There are several different types of budgets including the master budget, operating budget, financial budget, flexible budget, and operating budget.

1. What is the difference between budgeting and long-range planning?
2. What are the advantages and disadvantages of the bottom-up budgeting approach?

Answer: This approach begins at the lowest levels of management. These managers know the details involved with their departments. This allows for more accurate budget estimates when management understands how their department contributes to the company’s goals. Disadvantages include that this type of budgeting takes time, which leads to more labor costs, and when management doesn’t fully understand how it contributes to the company goals, the budget may support the department and not the company.

1. Why might a rolling budget require more management participation than an annual budget?
2. What information is necessary for the operating budgets?

Answer: Operating budgets plan the primary operations of the business and need accurate information in order to provide accurate planning. Assumptions such as sales in units, sales price, desired ending inventory in units, manufacturing costs per unit, which include direct material needed per unit, desired direct materials ending inventory, amount of direct labor hours and rate, and the overhead required for production and managing the company.

1. What operating budget exists for manufacturing but not for a retail company?
2. What is the process for developing a budgeted balance sheet?

Answer: The budgeted income statement includes the estimated revenue and expenses for the company. Using historical data on cash collections helps plan when the cash will be received and is used to develop the cash collections schedule. The company applies its payment policies on its purchases and other items requiring cash expenditures. This creates the cash payments schedule. Information from the cash collections schedule, cash payments schedule, and the capital expense budget are combined to develop the cash budget. The information from the cash budget and the ending balance sheet from the preceding year are used to develop the budgeted balance sheet.

1. Which of the financial budgets is the most important? Why?
2. A company has prepared the operating budget and the cash budget. It is now preparing the budgeted balance sheet. Identify the document that contains each of these balances. 1. cash . accounts receivable . finished goods inventory . accounts payable . equipment purchases

Answer: 1. cash budget
2. cash receipts budget
3. production budget
4. cash payments schedule
5. capital assets budge

1. Fill in the blanks: A flexible budget summarizes _______ and _______ for various volume levels by adjusting the _______ costs for the various levels of activities. The _______ costs remain the same for all levels of activities.
2. What information is included in the capital asset budget?

Answer: This budget is the plan for the purchase and disposal of plant assets and lists the estimated dollar amounts for each

1. Why does budget planning typically begin with the sales forecast?
2. What steps should be considered if a budget is to be set and later have its results evaluated?

Answer: Before the time period begins, the organization’s goals should be defined so the budget can be set to achieve the goals. During the time period, the results should be properly measured and reported so necessary changes can be made during the year. Then, the results of the operations can be evaluated and compared to the original budget and organization’s goals.

Exercise Set A
1. Blue Book printing is budgeting sales of $25,000$ units and already has $5,000$ in beginning inventory. How many units must be produced to also meet the $7,000$ units required in ending inventory?
2. How many units are in beginning inventory if $32,000$ units are budgeted for sales, $35,000$ units are produced, and the desired ending inventory is $9,000$ units?
3. Navigator sells GPS trackers for $\$50$ each. It expects sales of $5,000$ units in quarter 1 and a $5\%$ increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year.
4. One Device makes universal remote controls and expects to sell $500$ units in January, $800$ in February, $450$ in March, $550$ in April, and $600$ in May. The required ending inventory is $20\%$ of the next month’s sales. Prepare a production budget for the first four months of the year.
5. Sunrise Poles manufactures hiking poles and is planning on producing $4,000$ units in March and $3,700$ in April. Each pole requires a half pound of material, which costs $\$1.20$ per pound. The company’s policy is to have enough material on hand to equal $10\%$ of the next month’s production needs and to maintain a finished goods inventory equal to $25\%$ of the next month’s production needs. What is the budgeted cost of purchases for March?
6. Given the following information from Rowdy Enterprises’ direct materials budget, how much direct materials needs to be purchased?

1. Each unit requires direct labor of $2.2$ hours. The labor rate is $\$11.50$ per hour and next year’s direct labor budget totals $\$834,900$. How many units are included in the production budget for next year?
2. How many units are estimated to be sold if Skyline, Inc., has a planned production of $900,000$ units, a desired beginning inventory of $160,000$ units, and a desired ending inventory of $100,000$ units?
3. Cash collections for Wax On Candles found that $60\%$ of sales were collected in the month of the sale, $30\%$ was collected the month after the sale, and $10\%$ was collected the second month after the sale. Given the sales shown, how much cash will be collected in January and February?

1. Nonna’s Re-Appliance Store collects $55\%$ of its accounts receivable in the month of sale and $40\%$ in the month after the sale. Given the following sales, how much cash will be collected in February?

1. Dream Big Pillow Co. pays $65\%$ of its purchases in the month of purchase, $30\%$ the month after the purchase, and $5\%$ in the second month following the purchase. It made the following purchases at the end of 2017 and the beginning of 2018:

1. Desiccate purchases direct materials each month. Its payment history shows that $70\%$ is paid in the month of purchase with the remaining balance paid the month after purchase. Prepare a cash payment schedule for March if in January through March, it purchased $\$35,000$, $\$37,000$, and $\$39,000$, respectively.
2. What is the amount of budgeted cash payments if purchases are budgeted for $\$420,000$ and the beginning and ending balances of accounts payable are $\$95,000$ and $\$92,000$, respectively?
3. Halifax Shoes has $30\%$ of its sales in cash and the remainder on credit. Of the credit sales, $65\%$ is collected in the month of sale, $25\%$ is collected the month after the sale, and $5\%$ is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $\$75,000$ in June, $\$65,000$ in July, and $\$90,000$ in August?
4. Cold X, Inc. uses this information when preparing their flexible budget: direct materials of $\$2$ per unit, direct labor of $\$3$ per unit, and manufacturing overhead of $\$1$ per unit. Fixed costs are $\$35,000$. What would be the budgeted amounts for $20,000$ and $25,000$ units?
5. Using the provided budgeted information for production of $10,000$ and $15,000$ units, prepare a flexible budget for $17,000$ units.

1. The production cost for a waterproof phone case is $\$7$ per unit and fixed costs are $\$23,000$ per month. How much is the favorable or unfavorable variance if $5,500$ units were produced for a total of $\$61,000$?

Exercise Set B
1. Lovely Wedding printing is budgeting sales of $32,000$ units and already has $4,000$ in beginning inventory. How many units must be produced to also meet the $6,000$ units required in ending inventory?
2. How many units are in beginning inventory if $32,000$ units are budgeted for sales, $35,000$ units are produced, and the desired ending inventory is $9,000$ units?
3. Barnstormer sells airplane accessories for $\$20$ each. It expects sales of $120,000$ units in quarter 1 and a $7\%$ increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year.
4. Rehydrator makes a nutrition additive and expects to sell $3,000$ units in January, $2,000$ in February, $2,500$ in March, $2,700$ in April, and $2,900$ in May. The required ending inventory is $20\%$ of the next month’s sales, and the beginning inventory on January 1 was $600$ units. Prepare a production budget for the first four months of the year.
5. Cloud Shoes manufactures recovery sandals and is planning on producing $12,000$ units in March and $11,500$ in April. Each sandal requires $1.2$ yards if material, which costs $\$3.00$ per yard. The company’s policy is to have enough material on hand to equal $15\%$ of next month’s production needs and to maintain a finished goods inventory equal to $20\%$ of the next month’s production needs. What is the budgeted cost of purchases for March?
6. Given the following information from Power Enterprises’ direct materials budget, how much direct materials needs to be purchased?

1. Each unit requires direct labor of $4.1$ hours. The labor rate is $\$13.75$ per hour and next year’s production is estimated at $75,000$ units. What is the amount to be included in next year’s direct labor budget?
2. How many units are estimated to be sold if Kino, Inc., has planned production of $750,000$ units, a desired beginning inventory of $30,000$ units, and a desired ending inventory of $45,000$ units?
3. Cash collections for Renew Lights found that $65\%$ of sales were collected in the month of sale, $25\%$ was collected the month after the sale, and $10\%$ was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?

1. My Aunt’s Closet Store collects $60\%$ of its accounts receivable in the month of sale and $35\%$ in the month after the sale. Given the following sales, how much cash will be collected in March?

1. Gear Up Co. pays $65\%$ of its purchases in the month of purchase, $30\%$ in the month after the purchase, and $5\%$ in the second month following the purchase. What are the cash payments if it made the following purchases in 2018?

1. Drainee purchases direct materials each month. Its payment history shows that $65\%$ is paid in the month of purchase with the remaining balance paid the month after purchase. Prepare a cash payment schedule for January using this data: in December through February, it purchased $\$22,000$, $\$25,000$, and $\$23,000$ respectively.
2. What is the amount of budgeted cash payments if purchases are budgeted for $\$190,500$ and the beginning and ending balances of accounts payable are $\$21,000$ and $\$25,000$, respectively?
3. Earthie’s Shoes has $55\%$ of its sales in cash and the remainder on credit. Of the credit sales, $70\%$ is collected in the month of sale, $15\%$ is collected the month after the sale, and $10\%$ is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $\$75,000$ in April, $\$65,000$ in May, and $\$90,000$ in June?
4. Judge’s Gavel uses this information when preparing their flexible budget: direct materials of $\$3$ per unit, direct labor of $\$2.50$ per unit, and manufacturing overhead of $\$1.25$ per unit. Fixed costs are $\$49,000$. What would be the budgeted amounts for $33,000$ and $35,000$ units?
5. Using the following budgeted information for production of $5,000$ and $12,000$ units, prepare a flexible budget for $9,000$ units.

1. The production cost for UV protective sunglasses is $\$5.50$ per unit and fixed costs are $\$19,400$ per month. How much is the favorable or unfavorable variance if $14,000$ units were produced for a total of $\$97,000$?

Problem Set A
1. Lens Junction sells lenses for $\$45$ each and is estimating sales of $15,000$ units in January and $18,000$ in February. Each lens consists of $2$ pounds of silicon costing $\$2.50$ per pound, $3$ oz of solution costing $\$3$ per ounce, and $30$ minutes of direct labor at a labor rate of $\$18$ per hour. Desired inventory levels are:

Prepare a sales budget, production budget, direct materials budget for silicon and solution, and a direct labor budget.

1. 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.

1. Echo Amplifiers prepared the following sales budget for the first quarter of 2018:

It also has this additional information related to its expenses:

Prepare a sales and administrative expense budget for each month in the quarter ending March 31, 2018.

1. Prepare a budgeted income statement using the information shown.

1. Spree Party Lights overhead expenses are:

Prepare a manufacturing overhead budget if the number of units to produce for January, February, and March are $2,500$, $3,000$, and $2,700$, respectively.

1. Relevant data from the Poster Company’s operating budgets are:

Additional data: Capital assets were sold in January for $\$10,000$ and $\$4,500$ in May. Dividends of $\$4,500$ were paid in February. The beginning cash balance was $\$60,359$ and a required minimum cash balance is $\$59,000$. Use this information to prepare a cash budget for the first two quarters of the year.

1. Fill in the missing information from the following schedules:

1. Direct labor hours are estimated as $2,000$ in Quarter 1; $2,100$ in Quarter 2; $1,900$ in Quarter 3; and $2,300$ in Quarter 4. Prepare a manufacturing overhead budget using the information provided.

1. Fitbands’ estimated sales are:

What are the balances in accounts receivable for January, February, and March if $65\%$ of sales is collected in the month of sale, $25\%$ is collected the month after the sale, and $10\%$ is second month after the sale?

1. Sports Socks has a policy of always paying within the discount period and each of its suppliers provides a discount of $2\%$ if paid within $10$ days of purchase. Because of the purchase policy, $85\%$ of its payments are made in the month of purchase and $15\%$ are made the following month. The direct materials budget provides for purchases of $\$129,582$ in November, $$294,872$ in December, $\$239,582$ in January, and $\$234,837$ in February. What is the balance in accounts payable for January 31, and February 28?
2. Prepare a flexible budgeted income for $120,000$ units using the following information from a static budget for $100,000$ units:

1. Before the year began, the following static budget was developed for the estimated sales of $100,000$. Sales are sluggish and management needs to revise its budget. Use this information to prepare a flexible budget for $80,000$ and $90,000$ units of sales.

1. Caribbean Hammocks currently sells $75,000$ units at $\$50$ per unit. Its expenses are:

Management believes it can increase sales by $5,000$ units for every $\$5$ decrease in sales price. It also believes the additional sales will allow a decrease in direct material of $\$1$ for each additional $5,000$ units. Prepare a flexible budgeted income statement for $75,000-$, $80,000-$, and $85,000-$ unit sales.

1. Total Pop’s data show the following information:

New machinery will be added in April. This machine will reduce the labor required per unit and increase the labor rate for those employees qualified to operate the machinery. Finished goods inventory is required to be $20\%$ of the next month’s requirements. Direct material requires $2$ pounds per unit at a cost of $\$3$ per pound. The ending inventory required for direct materials is $15\%$ of the next month’s needs. In January, the beginning inventory is $3,000$ units of finished goods and $4,470$ pounds of material. Prepare a production budget, direct materials budget, and direct labor budget for the first quarter of the year.

1. Identify the document that contains the information listed in these lines from the budgeted balance sheet shown. 1. Cash . Accounts receivable . Raw materials inventory . Computers . Accounts payable

1. Titanium Blades refines titanium for use in all brands of razor blades. It prepared a static budget for the sales of $5,000$ units. These variances were observed:

Determine the static budget and use the information to prepare a flexible budget and analysis for the $6,000$ units actually sold.

Problem Set B
1. Lens & Shades sells sunglasses for $\$37$ each and is estimating sales of $21,000$ units in January and $19,000$ in February. Each lens consists of $2.00$ mm of plastic costing $\$2.50$ per mm, $1.7$ oz of dye costing $\$2.80$ per ounce, and $0.50$ hours direct labor at a labor rate of $\$18$ per unit. Desired inventory levels are:

Prepare a sales budget, production budget, direct materials budget for silicon and solution, and a direct labor budget.

1. 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.

1. TIB makes custom guitars and prepared the following sales budget for the second quarter

It also has this additional information related to its expenses:

Direct material per unit $\$55$, Direct labor per hour $20$, Variable manufacturing overhead per hour $3.50$, Fixed manufacturing overhead per month $3,000$, Sales commissions per unit $20$, Sales salaries per month $5,000$, Delivery expense per unit $0.50$, Utilities per month $4,000$, Administrative salaries per month $20,000$, Marketing expenses per month $8,000$, Insurance expense per month $11,000$, Depreciation expense per month $9,000$.

Prepare a sales and administrative expense budget for each month in the quarter ended June 30, 2018.

1. Prepare a budgeted income statement using the information shown.

1. Sunshine Gardens overhead expenses are:

Given production of $10,200$; $11,300$; $12,900$; and $13,200$ for each quarter of the next year, prepare a manufacturing overhead budget for each quarter.

1. Relevant data from the operating budget of The Framers are:

Other data:

* Capital assets were sold in quarter 1 and $\$8,000$ was collected in quarter 1 and $\$500$ collected in quarter 2.
* Dividends of $\$500$ will be paid in May
* The beginning cash balance was $\$50,000$ and a required minimum cash balance is $\$10,000$.
* Prepare a cash budget for the first two quarters of the year.

1. Fill in the missing information from the following schedules:

1. Mesa Aquatics, Inc. estimated direct labor hours as $1,900$ in quarter 1, $2,000$ in quarter 2, $2,200$ in quarter 3, and $1,800$ in quarter 4. a sales and administration budget using the information provided.

1. Amusement tickets estimated sales are:

What are the balances in accounts receivable for April, May, and June if $60\%$ of sales are collected in the month of sale, $30\%$ are collected the month after the sale, and $10\%$ are collected the second month after the sale?

1. All Temps has a policy of always paying within the discount period, and each of its suppliers provides a discount of $2\%$ if paid within $10$ days of purchase. Because of the purchase policy, $80\%$ of its payments are made in the month of purchase and $20\%$ are made the following month. The direct materials budget provides for purchases of $\$23,812$ in February, $\$23,127$ in March, $\$21,836$ in April, and $\$28,173$ in May. What is the balance in accounts payable for April 30, and May 31?
2. Prepare a flexible budgeted income statement for $47,000$ units using the following information from a static budget for $45,000$ units:

1. Before the year began, the following static budget was developed for the estimated sales of $50,000$. Sales are higher than expected and management needs to revise its budget. Prepare a flexible budget for $100,000$ and $110,000$ units of sales.

1. Artic Camping Gear’s currently sells $35,000$ units at $\$73$ per unit. Its expenses are as follows:

Management believes it can increase sales by $2,000$ units for every $\$5$ decrease in sales price. It also believes the additional sales will allow a decrease in direct material of $\$1$ for each additional $2,000$ units. Prepare a flexible budgeted income statement for $35,000-$, $37,000-$, and $39,000-$ unit sales.

1. Fruit Tea’s data show the following information:

New machinery will be added in October. This machine will reduce the labor required per unit and increase the labor rate for those employees qualified to operate the machinery. Finished goods inventory is required to be $20\%$ of the next month’s requirements. Direct material requires $2.5$ pounds per unit at a cost of $\$5$ per pound. The ending inventory required for direct materials is $20\%$ of the next month’s needs. In August, the beginning inventory is $3,750$ units of finished goods and $13,125$ pounds of materials. Prepare a production budget, direct materials budget, and direct labor budget for the first quarter of the year.

1. Identify the document that contains the information listed in these lines from the budgeted balance sheet shown. 1. Accounts receivable . Finished goods inventory . Machinery . Accumulated depreciation . Notes payable . Common stock

1. Replenish sells shampoo that removes chlorine from hair. It prepared a static budget for the sales of 10,000 units. These variances were observed:

Determine the static budget and use the information to prepare a flexible budget and analysis for the 8,000 units actually sold.

Thought Provokers
1. Why is a clear understanding of management’s goals and objectives necessary for effective budgets?
2. It is proper budgeting procedure to begin with estimated revenues, but why might some nonprofit entities begin planning their expenditures instead of their revenues?
3. How would a human resources department use information in the operating budgets?
4. How would maintenance departments use information in the budget?
5. How might service industries predict revenue?
6. The management of Hess, Inc., is developing a flexible budget for the upcoming year. It was not pleased with the small amount of net income the budget showed at all sales levels and is contemplating using a less expensive material. This action reduces direct material cost by $1 per unit. What would be the effects on financial statements and a flexible budget if management takes this approach? Are there other factors that need to be considered?
7. When would a static budget be effective in evaluating a manager’s performance?
8. If management is being evaluated on their ability to manage a budget, what can they do to increase cash flow?
9. If management is being evaluated on their ability to manage a budget, what can they do to decrease cash outflow?

Contributors and Attributions