Qw. For the quarter ended March 31, 2020, Sheffield Company accumulates the following sales data for its newest guitar, The Edge:$327,200 budget: $301,900 actual.In the second quarter, budgeted sales were $381,500, and actual sales were $387,300.Prepare a static budget report for the second quarter and for the year to date.Product LineGuitar: The EdgeBudgetActualSecond QuarterSSFor the QDifference. Current Attempt in ProgressFor the quarter ended March 31, 2020, Sheffield Company accumulates the following sales data for its newest guitar, The Edge:$327,200 budget: $301,900 actual.In the second quarter, budgeted sales were $381,500, and actual sales were $387,300.Prepare a static budget report for the second quarter and for the year to date.Yt30, 2020BudgetActualYear to DateDifference

The static budget report is prepared to show the difference between the budgeted values and the…

For the quarter ended March 31, 2020, Sheffield Company accumulates the following sales data for its newest guitar, The Edge: $327,200 budget: $301,900 actual. In the second quarter, budgeted sales were $381,500, and actual sales were $387,300. Prepare a static budget report for the second quarter and for the year to date. Product Line Guitar: The Edge Budget Actual Second Quarter S S For the Q Difference

For the quarter ended March 31, 2020, Sheffield Company accumulates the following sales data for its newest guitar, The Edge: $327,200 budget: $301,900 actual. In the second quarter, budgeted sales were $381,500, and actual sales were $387,300. Prepare a static budget report for the second quarter and for the year to date. Product Line Guitar: The Edge Budget Actual Second Quarter S S For the Q Difference

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter7: The Master Budget And Flexible Budgeting

Section: Chapter Questions

Problem 4E: Prepare a cost of goods sold budget for the Crest Hills Manufacturing Co. for the year ended...

See similar textbooks

Similar questions

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.
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 year
Prepare a sales budget. Palermo Company estimates that unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 15,000 in quarter 3; and 18,000 in quarter 4. Using a sales price of $70 per unit, prepare the sales budget by quarters for the year ending December 31, 2019. Palermo Company Sales Budget For the Year Ending December 31, 2019 Description Q1 Q2 Q3 Q4 Year Estimates sales Sales price x unit Sales Revenue
Prepare a sales budget. Palermo Company estimates that unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 15,000 in quarter 3; and 18,000 in quarter 4. Using a sales price of $70 per unit, prepare the sales budget by quarters for the year ending December 31, 2019. Palermo Company Sales Budget For the Year Ending December 31, 2019 Description Q1 Q2 Q3 Q4 Year Estimates sales Sales price x unit Sales Revenue 2. Prepare a production budget for 2 quarters. Sales budget data for Palermo Company are given in exercise 1. Management desires to have an ending finished goods inventory equal to 25% of the next quarter's expected unit sales. Prepare a production budget by quarters for the first 6 months of 2019. Palermo Company Direct Labor Budget For the Six Months Ending June 30, 2019…
For the quarter ended March 31, 2022, Pina Colada Company accumulates the following sales data for its newest guitar, The Edge: $321,300 budget; $311,100 actual. In the second quarter, budgeted sales were $387,600, and actual sales were $391,680. Prepare a static budget report for the second quarter and for the year to date. Y 22 ÷ tA $ Budget Year to Date Actual Difference $ $
Prepare a Sales Budget, Purchases Budget and Forecasted Income Statement for 2022 third quarter of Maryland Enterprises. Using the ff. data: June July August September Units to be Sold 1,000 1,250 1,500 1,350 Selling Price P190 Unit Cost P120 Beginning Inv for July 100 units Desired Ending Inventory 10% of Last month Unit Sales ling Expenses P25 per forecasted sales in units Administrative Expenses P10,000 per month
Paige Company estimates that unit sales will be 10,000 in quarter 1, 14,000 in quarter 2, 15,000 in quarter 3, and 18,000 in quarter 4. Using a sales price of $70 per unit.Prepare the sales budget by quarters for the year ending December 31, 2020. PAIGE COMPANYSales Budgetchoose the accounting period Quarter 1 2 3 4 Year select an opening name enter a number of units enter a number of units enter a number of units enter a number of units enter a total for the row select an item $enter a dollar amount $enter a dollar amount $enter a dollar amount $enter a dollar amount $enter a dollar amount select a closing name $enter a product of the two previous amounts $enter a product of the two previous…
@ In September 2019, the budget committee of Jason Company assembles the following data: 1. Expected Sales W S 2. 3. 4. October November December 1,600,000 Cost of goods sold is expected to be 60% of sales. Desired ending merchandise inventory is 20% of the next month's cost of goods sold. The beginning inventory at October 1 will be the desired amount. #3 $1,800,000 Prepare the budgeted income statement for October through gross profit on sales, including a cost of goods sold schedule E D 1,700,000 $ 4 R F JASON COMPANY Budgeted Income Statement For the Month Ended October 31, 2019 16 % 5 T G MacBook Pro 6 tv Y & 7 H U * 00 8 1 zoom ( 9 J K DII
Sunland Company makes and sells artistic frames for pictures. The controller is responsible for preparing the master budget and has accumulated the following information for 2022. Estimated unit sales Unit selling price Direct labor hours per unit Direct labor cost per hour January 11,280 $40 2.0 $7.0 February March April 13,160 12,220 10,340 $37.5 $37.5 2.0 $7.0 1.5 $7.0 $37.5 1.5 $8.0 May 10,340 $37.5 1.5 $8.0 Sunland has a labor contract that calls for a wage increase to $8.0 per hour on April 1. New labor-saving machinery has been installed and will be fully operational by March 1. Sunland expects to begin the year with 16,544 frames on hand and has a policy of carrying an end-of-month inventory of 100% of the following month's sales, plus 40% of the second following month's sales. SUP
Styles Abuhatim LLC has given the following particulars. You are required to prepare a cash budget for the three months ending 31st December 2019 Months Sales Materials Wages ( OMR) Over heads (OMR) (OMR) (OMR) August September October 20000 10200 3800 1900 21000 10000 3800 2100 23000 9800 4000 2300 November 25000 10000 4200 2400 December 30000 10800 4500 2500 Credit terms are 1.. Sales /Debtors 10% sales are on Cash, 50% of the credit sales are collected in next month and the balance in the following month 2. Creditors- materials 2 months Wages 1 month -1 month Overheads 3. Cash balance on 1st October is expected to be Ro.8000 4. A machinery will be installed in August at a cost of RO.100000, the monthly instalment of RO.5000 is payable from October onwards 5. Dividend at 10% on preference share capital RO.300,000 will be paid on 1* December 2019 6. Advance to be received for the sale of vehicles RO.20000in December 7. Income tax to be received in December RO.5000
In September 2019, the budget committee of Jason Company assembles the following data: 1. 2 Expected Sales 4. October November December Cost of goods sold is expected to be 60% of sales. 3. Desired ending merchandise inventory is 20% of the next month's cost of goods sold. The beginning inventory at October 1 will be the desired amount. $1,800,000 1,700,000 V 1,600,000 Prepare the budgeted income statement for October through gross profit on sales, including a cost of goods sold schedule. V M JASON COMPANY Budgeted Income Statement For the Month Ended October 31, 2019 $ $
On January 1, 2022, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2022. Sales units: Ending raw materials inventory: Ending finished goods inventory: Third-quarter production: First quarter 5,000; second quarter 6,000; third quarter 7,000. 40% of the next quarter's production requirements. 25% of the next quarter's expected sales units. 7,200 units. The ending raw materials and finished goods inventories at December 31, 2021, follow the same percentage relationships to production and sales that occur in 2022. Three pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $4 per pound.