Coronado Company estimates that unit sales will be 9,200 in quarter 1, 12,880 in quarter 2, 13,800 in quarter 3, and 16,560 in quarter4. Using a unit selling price of $70 per unit.Prepare the sales budget by quarters for the year ending December 31, 2027.$$1$$CORONADO COMPANYSales Budget2Quarter$3$$ [$

A sales budget is a financial plan that estimates the expected sales revenue for a certain period.…

Answered: Coronado Company estimates that unit…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

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…
Prepare a sales budget for 2 quarters Exercise 1 Trusler Electronics Inc. produces and sells two models of pocket calculators, XQ-103 and XQ-104. The sell for calculators $14.00 and $26.00 Trespectively. Because of the intense competition Trusler faces, management budgets sales semiannually. Its projections for the first 2 quarters of 2022 are as follows. Unit Sales Quarter 2 26,000 Product Quarter 1 ХО-103 21,000 ХО-104 13,000 16,000 No changes in selling prices are anticipated. Instructions: Prepare a sales budget for the 2 quarters ending June 30, 2022 using the below budget table. List the products and show for each quarter and for the 6 months, units, selling price, and total sales by product and in total. TRUSLER ELECTRONICS INC. Sales Budget For the Six Months Ending June 30, 2020 Quarter 1 Quarter 2 Six Months Product Selling Units Selling Price Total Sales Units Selling Price Total Sales Units Total Sales Price ХО-103 ХО-104 Totals
Question 1 TinyTom makes one product, which sells for $70 each, and prepares functional budgets on a monthly basis. For the first three months of 2021, the following figures are proposed: Sales January 10,000 units February 14,000 units March 12,000 units 10,000 April A closing stock of 10% of the next month's sales is required, the forecast sales for April is 10,000 units. The standard material cost of one unit of finished product is: Material X 4 units at $2 per unit Material Y 8 units at $3 per unit Material Z 2 unit at $5 per unit The standard direct labour cost of one unit of finished product is: 4 hours at $5 per hour Department A Department B Department C 4 hours at $5 per hour 2 hours at $4 per hour Material X Y Material Opening Stock Closing Stock 75,000 80,000 15,000 60,000 75,000 12,500 Required: 1) Calculate the standard prime cost of one unit of finished product. ii) Calculate the Sales Budget for each of months. iii) Calculate the Production Budget for each of months. iv)…
Market Leasing budgeted credit sales in the first quarter of 2014 to be as follows: January $210,000 February 190,000 March 170,000 The budgeted beginning cash balance at February 1 is expected to be $14,000 and budgeted monthly cash disbursements are expected to be $198,000. Credit sales in December, 2013 are expected to be $204,000. The company expects to collect 20% of a month’s sales in the month of sale and 80% in the following month. How much is the budgeted cash balance at the end of February?
Hh2. Account
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced 7,680 8,480 8,860 8,860 33,880 Direct material per unit 2 2 2 2 2 Total pounds needed for production 15,360 16,960 17,720 17,720 67,760 Add: Desired ending inventory 4,240 4,430 4,430 3,600 3,600 Total material required 19,600 21,390 22,150 21,320 71,360 Less: Beginning inventory 4,240 4,430 4,430 Pounds of direct material purchase requirements 19,600 17,150 17,720 16,890 71,360 Cost per pound $1.50 $1.50 $1.50 $1.50 $1.50 Total cost of direct material purchase $29,400 $25,725 $26,580 $25,335 $107,040 Total $107,040 Direct Labor Budget For the Year Ending Dec. 31, 2018 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Units to be produced 7,680 8,480 8,860 Direct labor hours per unit 0.75 0.75 0.75 0.75 0.75 Total required direct labor hours 5,760 6,360 6,645 6,645 Labor cost per hour $25 $25 $25 $25 $25 Total direct labor cost $144,000 $159,000 $166,125 $ $635,250
Management Accounting Course Project – Part 1, B Group The Terranova Company is preparing information to complete its master budget for the quarter ending December 31, 2020. The company intends to make unit sales in the related months as follows: September 5,000 October 9,750 November 11,700 December 14,625 Units are to be sold for $10 each. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following the sale. *Required: 1) Prepare a sales budget for Terranova for the quarter ending December 31, 2020. Show activity by month and in total. (Hint: a quarter = 3 months.) 2) Complete a schedule of expected cash collections for the quarter ending December 31, 2020. Show activity by month and in total.
COVID 19 Co has forecast purchases on account to be $312.000 in March, $377.000 in April, $421,000 in May, and $499,000 in June. Sixty percent of purchases are paid for in the month of purchase, the remaining 40% are paid in the following month. What are budgeted cash payments for May? Select one Oa $351.000 b. S403.400 C $125.000 Od $384.000
Surf Inc. has prepared the sales forecast as shown below: Description Month 1 Month 2 Month 3 Month 4 Sales Forecast 25,000.00 27,000.00 29,000.00 23,000.00 Prepare the production budget and show the required production for Months 1-3 Beg Inv Month 1 3,500.00 Required Ending Inventory 15% of the next months budgeted sales Description Month 1 Month 2 Month 3
Question 9
Part B Tamy Sdn Bhd produces wooden desks. The following estimates are provided for the month of May, June, July and August 2021. Budgeted wooden desk sales in units 8,000 7,000 6,000 5,000 May June July August The estimated selling price is RM120 per unit. Tamy Sdn Bhd wants to have 10% of the next month's sales in units on hand at the end of each month. REQUIRED a) Prepare the sales budget for the month of May, June , July and Total 2021. b) Prepare the production budget for the month of May, June, July and Total 2021.
Give answer as per required

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS