Question
Tamarisk Inc. is preparing its annual budgets for the year ending December 31, 2022. Accounting assistants have provided the following data: Product LN 35 Product
Tamarisk Inc. is preparing its annual budgets for the year ending December 31, 2022. Accounting assistants have provided the following data:
Product LN 35 | Product LN 40 | ||||
---|---|---|---|---|---|
Sales budget | |||||
Expected volume in units | 402,000 | 241,000 | |||
Unit selling price | $31 | $35 | |||
Production budget | |||||
Desired ending finished good units | 31,000 | 21,000 | |||
Beginning finished goods units | 21,000 | 16,000 | |||
Direct materials budget: | |||||
Direct materials per unit (kilograms) | 2 | 3 | |||
Desired kilograms of ending direct materials | 47,000 | 15,000 | |||
Beginning kilograms of direct materials | 40,000 | 10,000 | |||
Cost per kilogram | $2 | $3 | |||
Direct labour budget | |||||
Direct labour time per unit (hours) | 0.50 | 0.70 | |||
Direct labour rate per hour | $13 | $13 | |||
Budgeted income statement | |||||
Total unit cost | $12 | $21 |
An accounting assistant has prepared the detailed manufacturing overhead budget and the selling and administrative expenses budget. The latter shows selling expenses of $849,000 for product LN 35 and $388,000 for product LN 40, and administrative expenses of $521,000 for product LN 35 and $180,000 for product LN 40. Income taxes are expected to be 30%.
Prepare the sales budget for the year.
TAMARISK INC. Sales Budget For the Year Ending December 31, 2022 | ||||||
---|---|---|---|---|---|---|
LN 35 | LN 40 | Total | ||||
Expected sales in units | enter a number of units | enter a number of units |
| |||
Unit selling price | $enter a dollar amount | $enter a dollar amount |
| |||
Total sales | $enter a total dollar amount | $enter a total dollar amount | $enter a total dollar amount |
Prepare the production budget for the year.
TAMARISK INC. Production Budget For the Year Ending December 31, 2022 | ||||||
---|---|---|---|---|---|---|
LN 35 | LN 40 | Total | ||||
select an opening production budget item Required production in unitsExpected sales in unitsTotal required unitsBeginning finished goods inventoryDesired ending finished goods | enter a number of units | enter a number of units | ||||
select between addition and deduction AddLess: select a production budget item Total required unitsExpected sales in unitsBeginning finished goods inventoryDesired ending finished goodsRequired production in units | enter a number of units | enter a number of units | ||||
select a summarizing line for the first part Total required unitsExpected sales in unitsDesired ending finished goodsRequired production in unitsBeginning finished goods inventory | enter a total number of units for the first part | enter a total number of units for the first part | ||||
select between addition and deduction LessAdd: select a production budget item Expected sales in unitsRequired production in unitsBeginning finished goods inventoryDesired ending finished goodsTotal required units | enter a number of units | enter a number of units | ||||
select a closing production budget item Expected sales in unitsRequired production in unitsDesired ending finished goodsBeginning finished goods inventoryTotal required units | enter a total number of units | enter a total number of units | enter a total number of units |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started