FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Related questions
Concept explainers
Question
Based on the following production and sales data of Frixion Co. for March of the current year, prepare the following:
| Product T | Product X | ||||
| Estimated inventory, March 1 | 28,000 | units | 20,000 | units | |
| Desired inventory, March 31 | 32,000 | units | 15,000 | units | |
| Expected sales volume: | |||||
| Territory I | 320,000 | units | 260,000 | units | |
| Territory II | 190,000 | units | 130,000 | units | |
| Unit sales price | $6 | $14 |
i need help creating a production budget
| Frixion Co. | ||
| Production Budget | ||
| For the Month Ending March 31 | ||
| Product T | Product X | |
| Sales (units) | ||
| Total (units) available | ||
| Total units to be produced |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
Hello, for this same problem, what is the sales budget?
Transcribed Image Text:Estimated inventory, March 1
Desired inventory, March 31
Expected sales volume:
Area I
Area II
Unit sales price
a. Prepare a sales budget.
Product and Area
Product T:
Area I
Area II
Total
Product X:
Area I
Area II
Total
Product T
Total revenue from sales
28,000 units
32,000 units
320,000 units
190,000 units
$6
Product X
20,000 units
15,000 units
260,000 units
130,000 units
$14
Frixion Co.
Sales Budget
For Month Ending March 31
Unit Sales Volume Unit Selling Price Total Sales
8
1101000
Solution
by Bartleby Expert
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
Hello, for this same problem, what is the sales budget?
Transcribed Image Text:Estimated inventory, March 1
Desired inventory, March 31
Expected sales volume:
Area I
Area II
Unit sales price
a. Prepare a sales budget.
Product and Area
Product T:
Area I
Area II
Total
Product X:
Area I
Area II
Total
Product T
Total revenue from sales
28,000 units
32,000 units
320,000 units
190,000 units
$6
Product X
20,000 units
15,000 units
260,000 units
130,000 units
$14
Frixion Co.
Sales Budget
For Month Ending March 31
Unit Sales Volume Unit Selling Price Total Sales
8
1101000
Solution
by Bartleby Expert
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Please give answer the questionarrow_forwardCurrent Attempt in Progress The following data relate to a year's budgeted activity for Blossom Limited, a company that manufactures one product: Beginning inventory Production Available for sale Sales Ending inventory Units 41,360 144,760 (a) 186,120 134,420 Selling price Variable manufacturing costs Variable selling, general, and administrative expenses Fixed manufacturing costs (based on 100,000 units) Fixed selling, general, and administrative expenses (based on 100,000 units) (b) 51,700 Total fixed costs and expenses remain unchanged within the relevant range of 25,000 units to a total capacity of 160,000 units. Calculate the projected net income for the year under variable costing. Per unit $8.00 Projected net income $ 3.00 3.00 0.55 0.85arrow_forwardDiane Buswell is preparing the 2022 budget for one of Current Designs' rotomolded kayaks. Extensive meetings with members of the sales department and executive team have resulted in the following unit sales projections for 2022. Quarter 1 1,300 kayaks Quarter 2 2,000 kayaks Quarter 3 950 kayaks Quarter 4 950 kayaks Current Designs' policy is to have finished goods ending inventory in a quarter equal to 25% of the next quarter's anticipated sales. Preliminary sales projections for 2023 are 1,100 units for the first quarter and 2,000 units for the second quarter. Ending inventory of finished goods at December 31, 2021, will be 325 rotomolded kayaks. Production of each kayak requires 44 pounds of polyethylene powder and a finishing kit (rope, seat, hardware, etc.). Company policy is that the ending inventory of polyethylene powder should be 20% of the amount needed for production in the next quarter. Assume that the ending inventory of polyethylene powder on December 31, 2021, is 21,800…arrow_forward
- How do I prepare the selling and administrative expense budget for the quarter ended March 31, 20X1?arrow_forwardProduction and sales estimates for March for Robin Co. are as follows: Estimated inventory ( units), March 117,100 Desired inventory (units), March 31 19,700 Expected sales volume ( units): Area M 6,500 Area L 9,300 Area O 7, 100 Unit sales price $17 Budgeted production for March is a. 42, 600 b. 22,900 c. 59,700 d. 25,500arrow_forwardFunction: 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…arrow_forward
- Provide solution for this questionarrow_forwardYou have been presented with the following information by the Budget Committee of the organization in which you work: Sales forecast January – April 2020 Details Study lamps Accent lights Expected selling price per unit $300 $500 Sales Volume forecast: January 2 000 units 1 000 units February 2 500 units 1 500units March 3 000 units 1 000 units April 2 000 units 1 200 units Additional information: (i) Beginning inventories: study lamps 300 units; accent lights 200 units. (ii) The ending inventory for each product at the end of each month is to be maintained at 20% of the budgeted sales for the next month. (iii) To make one study lamp, four (4) units of raw material lumber are used, while five (5) units of raw material aluminum are used to make one accent lights. Required: The Sales Budget for both products for January to March 2020. The Direct Material usage budget.arrow_forwardPlease complete a and barrow_forward
- The marketing department of Teddy Bear Company has submitted the following sales forecast for the upcoming fiscal year. Quarter 1 Quarter 2 Quarter 3 Quarter 4 Budgeted unit sales 120,000 130,000 125,000 125,000 The company expected to start the first quarter with 20,000 units in finished goods in inventory. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter’s budgeted sales. The desired ending finished goods inventory for the fourth quarter s 25,000 units. Prepare the company’s production budget for the second quarter.arrow_forwardEX.22-06 Sales and Production Budgets Sonic Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget. Estimated inventory (units), June 1 Desired inventory (units), June 30 Expected sales volume (units): East Region West Region Unit sales price Rumble 262 301 2,700 5,900 $140 Thunder 66 57 2,400 5,150 $205arrow_forwardMango Place has forecast its sales for the coming months as follows: Standard Units 102 April May June July 121 139 162 The standard model sells for $214. Required: Prepare a sales budget for the quarter ending June 30. Budgeted unit sales Budgeted sales price Budgeted sales revenue Mango Place Sales Budget (Standard Model) For the Quarter Ending June 30 April May June Totalarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
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