Phoenix Company’s 2019 master budget included the following fixed budget report. It is based on an expected production and sales volume of 15,000 units. a. Classify all items listed in the fixed budget as variable or fixed. b. Also determine their amounts per unit or their amounts for the year, as appropriate. c. Identify the unit variable costs in the format of variable costing, according to your findings in part a
Q: Before the year began, the following static budget was developed for the estimated sales of 100,000.…
A: Budget is a forecast or an estimate of future outcomes of an entity. It is prepared by entity to…
Q: tar Company has a standard absorption and flexible budgeting system. Selected data for November 2020…
A: Total spending variance can be defined as the difference between actual overhead costs incurred and…
Q: Taylor corpration is analyzing the cost behavior of three cost items, A, B, and C, to budget for the…
A: Fixed expenses are the expenses which remains same irrespective of the level of output. Variable…
Q: Consider the following performance report for Jamie's Department Store for the month of October 2021…
A: Percentage increase in sales from Budget to Actual = (473,000 - 430,000)/430,000 = 10% Percentage…
Q: Collins Company is preparing its master budget for April. Use the given estimates to determine the…
A: Hey, since there are multiple questions posted, we will answer the first question. If you want any…
Q: Phoenix Company’s 2019 master budget included the following fixed budget report. It is based on an…
A: Variable Costing Income Statement: Variable costing income statement segregates fixed costs and…
Q: The following are the budgeted and the actual results for the month of April 2021 of Tommy Limited.…
A: Working Note: Production overhead (variable)=$325,000-$285,00029,000-25,000 units=$40,0004,000…
Q: The following production and cost information is for X Company for 2019: Budgeted 10,600…
A: 1) Static budget: Particulars Amount $ Variable cost (10,600 x 9.13) 96,778 Fixed cost…
Q: Phoenix Company's 2019 master budget included the following fixed budget report. It is based on an…
A: Solution: Flexible budget is the budget based on various level of activity to know what will be…
Q: total sales revenue be
A: Sales revenue means the amount of revenue earned from the sale of goods to customers.
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: For the year 2018, a company provides the following information: Description Amount Budgeted output…
A: Variance is considered as the difference between budgeted value and actual results. The management…
Q: ABC Ltd. is preparing a budget for 2018. Following are the information related to budget…
A: The flexible budget is prepared to estimate the expenses and revenue at different level of…
Q: he following information relates to a given department of Viernes Company for its fourth quarter of…
A: It is given that Actual total overhead - P178,500 Budget formula -P110,000 + P50 per hour Total…
Q: Before the year began, the following static budget was developed for the estimated sales of 50,000…
A: SOLUTION- FLEXIBLE BUDGET- IT IS A BUDGET WHICH IS ADJUSTED FOR ACTUAL OUTPUT . SO, THE BUDGET…
Q: Business Solutions's second-quarter 2020 fixed budget performance report for Its computer furniture…
A: The flexible budget performance report is prepared to analyse the difference between actual and…
Q: The following are estimates relating to its 2019 budget: Selling Price- Variable cost per…
A: "Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
Q: Mae Company prepared the following preliminary budget assuming no advertising expenditures: Selling…
A: Increased Sale price per unit=Sale price ×100+15%=P 10×115%=P 11.5
Q: At the start of 2021, X Company developed the following budgeted total cost function: $9.52X +…
A: Total Cost in a flexible budget is based on the actual number of units produced. In the given…
Q: Golden Inc. produces swimsuits. The following budgeted and actual amounts are for 2020: Cost Budget…
A: Budget is the estimate made for future period of time. Budgets are compared with actual results in…
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: For the year 2018, a company provides the following information. Description Amount Budgeted output…
A: Budgeted/Standard raw material price = $0.20 Actual raw material price = $0.18 Actual quantity =…
Q: ABC Company is preparing its master budget for 2014. Relevant data pertaining to its sales, I…
A: The forecast of the estimated sales or the quantity of the production to be done is called budget.…
Q: The Baldwin Company, in its master budget for 2019, predicted total sales of $168,000, variable…
A: Operating income: Operating income can be defined as the income generated by a business entity…
Q: Aaron's chairs is in the process of preparing a production cost budget for August. Actual costs in…
A:
Q: Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours.…
A: The flexible budget report compares the actual costs incurred and budgeted costs at actual…
Q: Preparing a flexible budget performance report Cell Plus Technologies manufactures capacitors for…
A:
Q: Myers Company uses a flexible budget for manufacturing overhead based on direct labor hours.…
A: Lets understand the basics. Flexible budget is prepared to calcualte the cost, sales and profit at…
Q: The next year's budget for Trend, Inc., a multi-product company, is given below: Product A Product B…
A: Sales mix variance is the variance in sales revenue due to difference in proportion of products…
Q: Collins Company is preparing its master budget for April. Use the given estimates to determine the…
A: Sales revenue is the revenue earned from the sale of product and services. Production units means…
Q: Collins Company is preparing its master budget for April. Use the given estimates to determine the…
A: Total sales = Sales of territory A + Sales of territory B Units produced = Sales + ending inventory…
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: Westport Company is preparing its master budget for May. Use the estimates provided to determine the…
A: Solution a: Budgeted sales = 150000*$65 = $9,750,000
Q: The following data were gathered from the Pal Company's overhead costs for the January, 2020…
A: Solution: Fixed overhead volume variance is calculated using formula = Fixed overhead applied -…
Q: Aaron's chairs is in the process of preparing a production cost budget for August. Actual costs in…
A: Total variable cost of 120 chairs = Materials cost + Labor cost = $4,730+2,940 = $7,670
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: Ivanhoe Manufacturing Co.s static budget at 13,500 units of production includes $87,750 for direct…
A: Direct material cost per unit = $20250/13500 =$1.50 per unit
Q: Elbert Company classifies its selling and administrative expense budget into variable and fixed…
A:
Q: Information relating to actual costs and variances for year 2019 is shown below. The budgeted…
A: Workings:
Q: Blossom Company's master budget reflects budgeted sales information for the month of June, 2022 as…
A: The sales budget details a company's sales expectations in both units and dollars for the budget…
Q: Jenner Company developed its annual manufacturing overhead budget for its master budget for 2008 as…
A: "Since you have asked multiple questions, we will solve first question for you. If you want any…
Q: What should total sales revenue be if territories A and B estimate sales of 10,000 and 13,000 units,…
A: No. of units sold in territory A (a) 10,000 No. of units sold in territory B (b) 13,000 Total…
Q: . What should total sales revenue be if territories E and W estimate sales of 50,000 and 100,000…
A:
Q: Phoenix Company’s 2019 master budget included the following fixed budget report. It is based on an…
A: Fixed cost are fixed in nature,it does not change with change in units of production.It remains…
Q: Sunland Company’s master budget reflects budgeted sales information for the month of June, 2022 as…
A: The sales budget is prepared to estimate the expected sales. It is also helpful to identify the gap…
Q: ts of $80,000. During the year ended December 31,2022, it produced 26,000 units.
A: Flexble budget represent the cost and revenue which directly vary with the change in output level.…
Q: Business Solutions's second-quarter 2020 fixed budget performance report for its computer furniture…
A: Flexible Budget Desk sales 194,040 186,480 / 148*154 Chair sales 32,640 28,560 / 56*64…
Q: Premised on past experience, Mayo Corp. adopted the following budgeted formula for estimating…
A: Flexible budget is that type of budget which changes with change in activity level. This type of…
Q: As sales manager, lohn was grven the following static budget report in the cothing dopartment of…
A: The flexible budget is prepared on the basis of actual results and standard rates. The variance is…
Phoenix Company’s 2019
a. Classify all items listed in the fixed budget as variable or fixed.
b. Also determine their amounts per unit or their amounts for the year, as appropriate.
c. Identify the unit variable costs in the format of variable costing, according to your findings in part a
d. Organize a template for variable costing income statements in which the sales volume is a variable.
e. Test your template for 15,000 units sales volume to see if you get the same income as stated above
f. Find the breakeven point and provide the income statement at break even
g. Provide income statement at sales volume 12,000, 14,000, 16,000, and 18,000
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
- Prepare a cost of goods sold budget for the Crest Hills Manufacturing Co. for the year ended December 31, 2016, from the following estimates. Inventories of production units: Direct materials purchased during the year, 854,000; beginning inventory of direct materials, 31,000; and ending inventory of direct materials, 26,000. Totals from other budgets included:Relevant data from the Poster Companys 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 yearRelevant 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.
- 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.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.
- 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.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.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,971
- Sales, production, direct materials, direct labor, and factory overhead budgets King Tire Co.s budgeted unit sales for the year 2016 were: The budgeted selling price for truck tires was 200 per tire, and for passenger car tires it was 65 per tire. The beginning finished goods inventories were expected to be 2,000 truck tires and 5,000 passenger tires, for a total cost of 326,478, with desired ending inventories at 2,500 and 6,000, respectively, with a total cost of 400,510. There was no anticipated beginning or ending work-in- process inventory for either type of tire. The standard materials quantities for each type of tire were as follows: The purchase prices of rubber and steel were 2 and 3 per pound, respectively. The desired ending inventories for rubber and steel were 60,000 and 6,000 lb, respectively. The estimated beginning inventories for rubber and steel were 75,000 and 7,000 lb, respectively. The direct labor hours required for each type of tire were as follows: The direct labor rate for each department is as follows: Budgeted factory overhead costs for 2016 were as follows: Required: Prepare each of the following budgets for King for the year ended December 31, 2016: 1. Sales budget. 2. Production budget. 3. Direct material budget. 4. Direct labor budget. 5. Factory overhead budget. 6. Cost of goods sold budget.Schedule of cash payments for service company Horizon Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: Depreciation, insurance, and property taxes represent 9,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. Seventy percent of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule of cash payments for selling and administrative expenses for March, April, and May.Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?