Exam #3 Practice i 29 ces Saved Help Save & Exit Subr Check my work Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 25,000 26,000 22,000 23,000 The company's variable selling and administrative expense per unit is $2.40. Fixed selling and administrative expenses include advertising expenses of $10,000 per quarter, executive salaries of $44,000 per quarter, and depreciation of $24,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in the third quarter. Finally, property taxes of $6,600 will be paid in the second quarter. Required: Prepare the company's selling and administrative expense budget for the upcoming fiscal year. Note: Round "Per Unit" answers to 2 decimal places.

Exam #3 Practice i 29 ces Saved Help Save & Exit Subr Check my work Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 25,000 26,000 22,000 23,000 The company's variable selling and administrative expense per unit is $2.40. Fixed selling and administrative expenses include advertising expenses of $10,000 per quarter, executive salaries of $44,000 per quarter, and depreciation of $24,000 per quarter. In addition, the company will make insurance payments of $5,000 in the first quarter and $5,000 in the third quarter. Finally, property taxes of $6,600 will be paid in the second quarter. Required: Prepare the company's selling and administrative expense budget for the upcoming fiscal year. Note: Round "Per Unit" answers to 2 decimal places.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 7CE: Refer to Cornerstone Exercise 8.6. Required: 1. Calculate the total budgeted cost of units produced...

See similar textbooks

Similar questions

Professional foes earned budget for a service company LundquistFret well. CPAs, offer three types of services to clents: auditing, tax, and small business accounting. Based on experience and projected growth, the following billable hours have been estimated for the year ending May 31. 20Y8: The average billing rate for staff is 140 per hour, and the average billing rate for partners is 450 per hour. Prepare a professional fees earned budget for Lundquist Fretwell, CPAs, for theyear ending May 31, 20Y8, using the following column headings and showing the estimated professional fees by type of service rendered:
Refer to Cornerstone Exercise 8.6. Required: 1. Calculate the total budgeted cost of units produced for Play-Disc for the coming year. Show the cost of direct materials, direct labor, and overhead. 2. Prepare a cost of goods sold budget for Play-Disc for the year. 3. What if the beginning inventory of finished goods was 75,200 (for 16,000 units)? How would that affect the cost of goods sold budget? (Assume Play-Disc uses the FIFO method.) Play-Disc makes Frisbee-type plastic discs. Each 12-inch diameter plastic disc has the following manufacturing costs: For the coming year, Play-Disc expects to make 300,000 plastic discs, and to sell 285,000 of them. Budgeted beginning inventory in units is 16,000 with unit cost of 4.75. (There are no beginning or ending inventories of work in process.) Required: 1. Prepare an ending finished goods inventory budget for Play-Disc for the coming year. 2. What if sales increased to 290,000 discs? How would that affect the ending finished goods inventory budget? Calculate the value of budgeted ending finished goods inventory.
Question Content Area Echo Amplifiers prepared the following sales budget for the first quarter of 2018: Jan. Feb. Mar. Units 800 1,200 1,500 Sales price $100 $100 $100 Budgeted sales $80,000 $120,000 $150,000 It also has this additional information related to its expenses: Direct material per unit $1.50 Direct labor per unit 2 Variable manufacturing overhead per hour 0.40 Fixed manufacturing overhead per month 2,900 Sales commissions per unit 15 Sales salaries per month 5,000 Delivery expense per unit 0.40 Factory utilities per month 4,000 Administrative salaries per month 20,000 Marketing expenses per month 9,000 Insurance expense per month 11,000 Depreciation expense per month 10,000 Prepare a sales and administrative expense budget for each month in the quarter ending March 31, 2018. Enter all amounts as positive numbers. Echo AmplifiersSales and Administrative BudgetFor the Quarter Ending March 31, 2018 January February March…
How do I prepare the bugdet and replace all question marks into formula?
Function: SUM; Formula: Subtract, Multiply; Cell Referencing Using Excel to Prepare a Production Budget PROBLEM Paige Company estimates that following unit sales and desired inventory level for the four quarters of the year ending December 31, 2022. Quarter 1 sales Quarter 2 sales Quarter 3 sales Quarter 4 sales Desired ending finished goods inventory based on next quarter's expected unit sales Unit selling price 10,000 14,000 15,000 18,000 25% $ 70.00 Prepare a production budget by quarters for the first 6 months of 2022. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or this work area as indicated. Use the SUM function with cell referencing for totals. Paige Company Production Budget For the Six Months Ending June 30, 2022 Quarter 1 10,000 Expected unit sales Add: Desired ending finished goods units Total required units Less: Beginning finished goods units Required production…
Please do not give solution in image format thanku
don't give answer in image format
please double underline need answer with explanation , computation for each requirement and part clearly answer in text need answer for all with complete and correct working
Please do not give solution in image format thanku
#1
Please help me with show all calculation thanku
Question 3 a) Why do successful companies tend to use the bottom-up approach to establish a master budget? b) Green Tea's data show the following information for the financial year, beginning July 2020: July Aug. Sept. Oct. Nov. Estimated sales (units) 25,000 25,000 27,000 27,500 28,000 Sales price per unit $31 $31 $31 $31 $31 Direct labour per unit $1.75 $1.75 $1.50 $1.50 $1.50 Labour rate per hour $21 $21 $24 $24 $24 New machinery will be added in September. This machine will reduce the labour required per unit and increase the labour 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 kg per unit at a cost of $5 per kg. The ending inventory required for direct materials is 20% of the next month's needs. In July, the beginning inventory is 3,750 units of finished goods and 13,125 kg of materials. Required: i) Prepare a production budget for the first quarter of the…