2. Prepare flexible budgets for the company at sales volumes of 14,000 and 16,000 units and classify all items listed in the fixed dget as variable or fixed.
Q: Daybreak Technologies Inc. uses flexible budgets that are based on the following data: Sales…
A: Solution: Flexible selling and administrative expense budget is as under:
Q: Before the year began, the following static budget was developed for the estimated sales of 100,000.…
A: A flexible budget is basically considered as those budget which adjusts them self to the interest or…
Q: ncoln Corporation used the following data to evaluate their current operating system. The company…
A: Solution: Actual operating income = sales - variable cost - fixed costs = 47000*10 - 167000 - 45000…
Q: dger Corporation is a service company that measures its output based on the number of customers…
A: The spending variance is the difference between flexible budget and actual budget of the business.
Q: The static budget, at the beginning of the month, for Divine Décor Company, follows: Static…
A: Flexible budget variance is the difference between budgeted sales revenue for actual units and the…
Q: Phoenix Company’s 2019 master budget included the following fixed budget report. It is based on an…
A: Hi student Since there are multiple subparts, we will answer only first three subparts.x
Q: Star Company has a standard absorption and flexible budgeting system. Selected data for November…
A: Total Spending Variance - The spending variance is the difference between the budgeted cost and the…
Q: Lincoln Corporation used the following data to evaluate their current operating system. The company…
A: Working note: ActualResults StaticBudget Static-budgetvariance Units sold 42000…
Q: allon Company uses flexible budgets to control its selling expenses. Monthly sales are expected to…
A: Budgeting: Budgeting is a process of preparing budgets and the evaluation of it to see whether the…
Q: Lincoln Corporation used the following data to evaluate their current operating system. The company…
A: Static budget is that budget which is fixed in nature and will not be change. But if level of…
Q: Daniels Corporation used the following data to evaluate their current operating system. The company…
A: Flexible budget vs static budget: Flexible budget is a budget which states the cost and sales…
Q: Hollaway Corp. has the following data for the current fiscal year: Actual Budget Sales…
A: Solution:- Calculation of the total sales mix variance for both products as follows:- For Product…
Q: 15,000 units sales volume to see if you get the same income as stated above Find the breakeven point…
A: Format of variable costing
Q: Schooner Corporation used the following data to evaluate its current operating system. The company…
A: The static budget variance of revenue is calculated as planned sales revenue less actual sales…
Q: Adger Corporation is a service company that measures its output based on the number of customers…
A: The variance is the difference between standard and actual data of production. The activity variance…
Q: Sanford Company original assumptions for the planning budget were: Total sales = $160,000, sale…
A: Given: Budgeted Quantity (BQ)=$160000$20=8000 unitsBudgeted Price (BP)=$20Actual Quantity (AQ)=8200…
Q: Daybreak Technologies Inc. uses flexible budgets that are based on the following data: Sales…
A: Sales commission = Total sales x 16% Advertising expense = Total sales x 12%
Q: The master budget at Western Company last period called for sales of 226,000 units at $10.00 each.…
A: The question is based on the concept of Cost Accounting.
Q: Adger Corporation is a service company that measures its output based on the number of customers…
A: Fixed cost remains same i.e. it doesn't changes with the changing level of production or sales…
Q: Based on predicted production of 24,200 units, a company budgets $330,000 of fixed costs and…
A: The flexible budget can be adjusted as per the requirements.
Q: Budgeted sales for the month are
A:
Q: The following information is given for one of a company's variable expenses: • The activity variance…
A: Planned hours 1000 Actual hours 900 Difference 100
Q: The following information was drawn from the accounting records of Smith Company Static Budget…
A: Variance is used by management to identify the gaps between expected results and actual results and…
Q: A company’s flexible budget for 19,000 units of production showed sales, $87,400; variable costs,…
A: Introduction:- The flexible budget is planned to change based on the level of units volume. It is…
Q: ABC prepared flexible budgets for possible 20X1 activity levels of 115, 140, and 165 are presented…
A: What is meant by Budgeting? It is the process of estimating the future revenues and outflows on the…
Q: Before the year began, the following static budget was developed for the estimated sales of 100,000.…
A: sales per unit = sales / number of units sold = $3570000 / 100000 = $37.5 Flexible budget at 80000…
Q: Bobs Consult, uses flexible budgeting for cost review purposes. The company’s master/static budget…
A: Supervisors Salary incurred for September month = $28000 Budgeted Supervisors salaries for the year…
Q: hooner Corporation used the following data to evaluate its current operating system. The company…
A: Solution: Actual revenues = Actual units * actual selling price = 171000 *23 = 3,933,000 Budgeted…
Q: Prestridge Corporation is a service company that measures its output by the number of customers…
A: 1. Expenses under planning budget = $41500 + (1000 * 31) + (500 *31) + $38900 = $41500 + $31000 +…
Q: Using the following budgeted information for production of 10,000 and 15,000 units, prepare a…
A: Fixed costs: Fixed costs means the costs that are not dependent on the level of production of goods…
Q: Classify all items listed in the fixed budget as variable or fixed. Also determine their amounts…
A: Hi student Since there are multiple subparts, we will answer only first three subparts.
Q: Fallon Company uses flexible budgets to control its selling expenses. Monthly sales are expected to…
A: Flexible Budget: A flexible budget is a budget that is prepared for different levels of the output.…
Q: Roger Company’ sells one product, and has provided the following variable and fixed estimates for…
A: Solution:- a)Calculation of the amount shown for revenue under the flexible and planning budget for…
Q: Brodrick Company expects to produce 21,700 units for the year ending December 31. A flexible budget…
A: At flexible budget, Selling price per unit = $542,500 / 21,700 units = $25 per unit So Total sales =…
Q: Prepare pro-forma budgets for activities within its relevant range of operations. Prepare a flexible…
A:
Q: Daybreak Technologies Inc. uses flexible budgets that are based on the following data: Sales…
A: Flexible Budget is an important elementary Budget system that help to estimate different income and…
Q: [The following information applies to the questions displayed below.] The fixed budget for 21,400…
A: Sales per unit = Total sales / No. of units sold = 470800/21400 = $22 per unit Variable cost per…
Q: Lincoln Corporation used the following data to evaluate their current operating system. The company…
A: static-budget variance of revenue = Actual revenue - Budget revenue
Q: From the following data, prepare flexible budget for production of 40000 units and 75000 units,…
A: A flexible budget is one that changes to a company's activity or volume levels i.e. Flexible budget…
Q: The following information was drawn from the accounting records of Smith Company Static Budget…
A: Sales price flexible budget variance = Actual sales - Flexible Budget Sales
Q: Required information [The following information applies to the questions displayed below.] Adger…
A: The activity variance is the difference between flexible budget and planning budget of the business.…
Q: Cold X, Inc. uses this information when preparing their flexible budget: direct materials of $2 per…
A: The following calculations are done in the records of Cold X Incorporation to evaluate their…
Q: Determine the static budget and use the information to prepare a flexible budget and analysis for…
A: Step 1 A budget is a pre estimation of revenue and expenses over a specified future period.
Q: Lincoln Corporation used the following data to evaluate their current operating system. The company…
A: Static budget is the original budget, which is not revised according to the actual units.
Q: The following data were collected by Allegro Company for the month of March: Static budget data:…
A: Flexible budget is prepared for actual level of activity based on static budget data for selling…
Q: If a flexible budget is prepared at a volume of 13,500 units, calculate the operating income. The…
A: Given: Particulars Per Unit Sales Revenue $20 Variable Cost $6 Fixed Cost 13500…
Q: 1) What amount of emplyee salaries and awages would be included in Adger's planning budget for May?…
A: Fixed cost remains same for the period, irrespective of the number of customers served. Variable…
Q: ohnson Corporation is preparing a flexible budget and desires to separate its lectricity expense,…
A: GIVEN Machine hours Electricity Expense January 3,500 P31, 500 February 2, 000 P20,000 March…
Q: If a company plans to sell 16,000 units of product but sells 20,000, the most appropriate comparison…
A: The most common appropriate comparison of the cost data associated with the sales will be by a…
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.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 5 images
- 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.: 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: 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 Prepare a budgeted income statement for 20Y9. Prepare a budgeted balance sheet as of December 31, 20Y9, with supporting calculations.Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: a. Finished goods inventory on January 1 is 32,000 units, each costing 166.06. The desired ending inventory for each month is 80% of the next months sales. b. The data on materials used are as follows: Inventory policy dictates that sufficient materials be on hand at the end of the month to produce 50% of the next months production needs. This is exactly the amount of material on hand on December 31 of the prior year. c. The direct labor used per unit of output is 3 hours. The average direct labor cost per hour is 14.25. d. Overhead each month is estimated using a flexible budget formula. (Note: Activity is measured in direct labor hours.) e. Monthly selling and administrative expenses are also estimated using a flexible budgeting formula. (Note: Activity is measured in units sold.) f. The unit selling price of the subassembly is 205. g. All sales and purchases are for cash. The cash balance on January 1 equals 400,000. The firm requires a minimum ending balance of 50,000. If the firm develops a cash shortage by the end of the month, sufficient cash is borrowed to cover the shortage. Any cash borrowed is repaid at the end of the quarter, as is the interest due (cash borrowed at the end of the quarter is repaid at the end of the following quarter). The interest rate is 12% per annum. No money is owed at the beginning of January. Required: 1. Prepare a monthly operating budget for the first quarter with the following schedules. (Note: Assume that there is no change in work-in-process inventories.) a. Sales budget b. Production budget c. Direct materials purchases budget d. Direct labor budget e. Overhead budget f. Selling and administrative expenses budget g. Ending finished goods inventory budget h. Cost of goods sold budget i. Budgeted income statement j. Cash budget 2. CONCEPTUAL CONNECTION Form a group with two or three other students. Locate a manufacturing plant in your community that has headquarters elsewhere. Interview the controller for the plant regarding the master budgeting process. Ask when the process starts each year, what schedules and budgets are prepared at the plant level, how the controller forecasts the amounts, and how those schedules and budgets fit in with the overall corporate budget. Is the budgetary process participative? Also, find out how budgets are used for performance analysis. Write a summary of the interview.At the beginning of the period, the Fabricating Department budgeted direct labor of 72,000 and equipment depreciation of 18,500 for 2,400 hours of production. The department actually completed 2,350 hours of production. Determine the budget for the department, assuming that it uses flexible budgeting.
- A companys controller is adjusting next years budget to reflect the impact of an expected 3 percent inflation rate. Listed below are selected items from next years budget before the adjustment. After adjusting for the 3 percent inflation rate, what is the companys total budget for the selected items before taxes for next year? a. 858,150 b. 860,412 c. 810,971 d. 858,971Budgeted selling and administrative expenses for King Tire Co. In P7-2 for the year ended December 31, 2016, were as follows: Required: 1. Prepare a selling and administrative expense budget, in good form, for the year 2016. 2. Using the information above and the budgets prepared in P7-2, prepare a budgeted income statement for the year 2016, assuming an income tax rate of 40%.Capital expenditures budget On August 1, 20Y4. the controller of Handy Dan Tools Inc. is planning capital expenditures for the years 20Y5-20Y8. The controller interviewed several Handy Dan executives to collect the necessary information for the capital expenditures budget. Excerpts of the interviews are as follows: Director of Facilities: A construction contract was signed in May 20Y4 for the construction of a new factory building at a contract cost of $9,000,000. The construction is scheduled to begin in 20Y5 and completed in 20Y6. Vice President of Manufacturing: Once the new factor)' building is finished, we plan to purchase $3-6 million in equipment in late 20Y6. I expect that an additional $500,000 will lx-needed early in the following year (20Y7) to test and install the equipment before we can begin production. If sales continue to grow, I expect we'll need to invest another half million in equipment in 20Y8. Vice President of Marketing: We have really been growing lately. I wouldn't be surprised if we need to expand the size of our new factory building in 20YS by at least 25%. Fortunately, we expect inflation to have minimal impact on construction costs over the next four years. Additionally, 1 would expect the cost of the expansion to Ik- proportional to the size of the expansion. Director of Information Systems: We need to upgrade our information systems to wireless network technology. It doesn't make sense to do this until after the new factory building is completed and producing product. During 20Y7, once the factor)' is up and running, we should equip the whole facility with wireless technology. I think it would cost us $400,000 today to install the technology. However, prices have been dropping by 10% per year, so it should be less expensive at a later date. President: I am excited about our long-term prospects. My only short-term concern is financing the $5,000,000 of construction costs on the portion of the new factor)' building scheduled to be completed in 20Y5. Use the interview information above to prepare a capital expenditures budget for Handy Dan Tools Inc. for the years 20Y5-20Y8.
- 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 2019 and 2020: 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: General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation 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 2019. 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 all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.Palmgren Company produces consumer products. The sales budget for four months of the year is presented below. Company policy requires that ending inventories for each month be 25 percent of next months sales. At the beginning of July, the beginning inventory of consumer products met that policy. Required: Prepare a production budget for the third quarter of the year. Show the number of units that should be produced each month as well as for the quarter in total.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.
- Sales and production budgets Ultimate Audio Company manufactures two models of speakers. U500 and S1000. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget.Capital expenditures budget On January 1, 20Y6, the controller of Omicron Inc. is planning capital expenditures for the years 20Y6-20Y9. The following interviews helped the controller collect the necessary information for the capital expenditures budget: Director of Facilities: A construction contract was signed in late 20Y5 for the construction of a new factory building at a contract cost of 10,000,000. The construction is scheduled to begin in 20Y6 and be completed in 20Y9. Vice President of Manufacturing: Once the new factory building is finished, we plan to purchase 1.5 million in equipment in late 20Y7. I expect that an additional 200,000 will be needed early in the following year (20Y8) to test and install the equipment before we can begin production. If sales continue to grow, I expect we'll need to invest another 1,000,000 in equipment in 20Y9. Chief Operating Officer: We have really been growing lately. I wouldn't be surprised if we need to expand the size of our new factory building in 20Y9 by at least 35%. Fortunately, we expect inflation to have minimal impact on construction costs over the next four years. Additionally, I would expect the cost of the expansion to be proportional to the size of the expansion. Director of Information Systems: We need to upgrade our information systems to wireless network technology. It doesn't make sense to do this until after the new factory building is completed and producing product. During 20Y8, once the factory is up and running, we should equip the whole facility with wireless technology. I think it would cost us 800,000 today to install the technology. However, prices have been dropping by 25% per year, so it should be less expensive at a later date. Chief Financial Officer: I am excited about our long-term prospects. My only short-term concern is managing our cash flow while we expend the 4,000,000 of construction costs in 20Y6 and 6,000,000 in 20Y7 on the portion of the new factory building scheduled to be completed in 20Y9. Use this interview information to prepare a capital expenditures budget for Omicron Inc. for the years 20Y6-20Y9.Performance Report Based on Budgeted and Actual Levels of Production Balboa Company budgeted production of 4,500 units with the following amounts: At the end of the year, Balboa had the following actual costs for production of 4,700 units: Required: 1. Calculate the budgeted amounts for each cost category listed above for the 4,500 budgeted units. 2. Prepare a performance report using a budget based on expected (budgeted) production of 4,500 units. 3. Prepare a performance report using a budget based on the actual level of production of 4,700 units.