Question

Note: The company desires a minimum ending cash balance each month on $35,000. The beard grooming products are sold to retailers for $20 each and the sales have been stagnant due to the Covid-19. However, the marketing department has been positive toward the end of the year due to season change and upcoming holiday. The marketing department has just sent you their forecasted quarter sales and marketing budget.

Quarter	2020 Q4	2021 Q1	2021 Q2	2021 Q3	2021 Q4	2022 Q1
Sales in Unit	30,000	35,000	40,000	65000	68000	70,000
Marketing Expenses	$35,000	$20,000	$20,000	$45,000	$45,000	$45,000

The increased sales volume before and during June and January is due to Father’s Day and holidays with AATB being a favorite. Ending finished goods inventories are supposed to be equal to 20% of the next month’s sales in units. AATB currently does its own assembly production in house. Each unit consists of 3 shaves and the cost of each is $1.50. Each unit needs 0.10 labour hour from assemble to finish package. The hourly pay rate to the assembling workers is $15 per hour. The production manager also required desired direct material ending inventory to 30% of the next quarter production.

• Purchases are paid for in the following manner: 50% in the quarter of the purchase and the remaining 50% paid in the quarter following the purchase. All sales to the distributors are made on credit terms with no discount (for now), and payable within 15 days. The AATB has determined that only 50% of sales are collected by the end of the quarter in which the sale occurred. An additional 30% is collected in the quarter following the sale, and the remaining 20% is collected in the second quarter following the sale. Bad debts have been negligible, supporting the credit terms as favorable.

Answer 1

	Q4	Q1	Q2	Q3	Q4	Q1
	2020	2021	2021	2021	2021	2022
Sales units	30000	35000	40000	65000	68000	70000
Sales price per unit	20	20	20	20	20	20
Total sales consideration	600000	700000	800000	1300000	1360000	1400000
Marketing expense	35000	20000	20000	45000	45000	45000
Inventory to be maintained	7000	8000	13000	13600	14000	0
Production Required	37000	36000	45000	65600	68400	56000
Direct Material ending inventory required	32400	40500	59040	61560	50400	0
Direct Material required for current month	111000	108000	135000	196800	205200	168000
Total direct material to be procured	143400	116100	153540	199320	194040	117600
Cost per unit	1.5	1.5	1.5	1.5	1.5	1.5
Direct Material costs	215100	174150	230310	298980	291060	176400
Labor hours	3700	3600	4500	6560	6840	5600
Cost per hour	15	15	15	15	15	15
Direct Labor costs	55500	54000	67500	98400	102600	84000

Inventory to be maintained	=next quarter's sales * 20%
Production required	=Closing inventory to be aintained + Current month's demand-opening inventory
Direct material ending inventory	=Next quarter's production *30% * 3 units per product
Direct Material for current month prodction	=production required * 3 units per product
Direct Material prcured	=Closing inventory to be maintained + current month's requirement-opening inventory
Labor hours required	=production required * 0.10 per product

Cashflow	Q4	Q1	Q2	Q3	Q4	Q1	Q2	Q3
	2020	2021	2021	2021	2021	2022	2022	2022
Payments for purchases
Payment for Q4 2020 Purchase	-107550	-107550
Payment for Q1 2021 Purchase		-87075	-87075
Payment for Q2 2021 Purchase			-115155	-115155
Payment for Q3 2021 Purchase				-149490	-149490
Payment for Q4 2021 Purchase					-145530	-145530
Payment for Q1 2022 Purchase						-88200	-88200
Receipt for Q4 2020 Sale	300000	180000	120000
Receipt for Q1 2021 Sale		350000	210000	140000
Receipt for Q2 2021 Sale			400000	240000	160000
Receipt for Q3 2021 Sale				650000	390000	260000
Receipt for Q4 2021 Sale					680000	408000	272000
Receipt for Q1 2022 Sale						700000	420000	280000
Marketing expenses payment	-35000	-20000	-20000	-45000	-45000	-45000	0
Wages payment	-55500	-54000	-67500	-98400	-102600	-84000
Balance	101950	261375	440270	621955	787380	1005270	603800	0 0 Add a comment Know the answer? Your Answer: Post as a guest Your Name: What's your source? Earn Coins Coins can be redeemed for fabulous gifts. Log In Sign Up Post as anonymous Post Your Answer Not the answer you're looking for? Ask your own homework help question Similar Questions Clarks Italian Ice is creating a sales budget for 2019. For the year, they expect to... Clarks Italian Ice is creating a sales budget for 2019. For the year, they expect to sell 100,000 cases of popsicles at a price of $20 per case for total budget sales of $2,000,000. For each quarter the budget unit sales are Q1-10,000 ; Q2-30,000; Q3-40,000 ; Q4-20,000. Of the total sales, Clarks Italian Ice expects to collect 70% in the current quarter and the remaining 30% in the following quarter. Desired Units of finished goods inventory is 20% of... Okay Company is preparing to build its master budget. The budget will detail each quarter’s activity... Okay Company is preparing to build its master budget. The budget will detail each quarter’s activity and the activity for the year in total. The master budget will be based on the following information: a. This will be the first year of operation for Okay Company. b. Budgeted unit sales by quarter for 2019 are projected as follows: First quarter 6,500, Second quarter 6,000, Third quarter 6,100 & Fourth quarter 6,250. First and second quarter 2020 budgeted sales units is... Requirement 2: The company has just hired a new marketing manager who insists that unit sales... Requirement 2: The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget:      Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2   Budgeted unit sales 45,000 70,000 110,000 70,000 85,000 90,000   Selling price per unit $7 per unit          Data Year 2 Quarter Year... The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal... The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 12,500 13,500 15,500 14,500 The selling price of the company’s product is $24 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning... The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal... The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 12,300 13,300 15,300 14,300 The selling price of the company’s product is $22 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning... The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal... The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account):     1st Quarter   2nd Quarter   3rd Quarter   4th Quarter Budgeted unit sales   12,500   13,500   15,500   14,500 The selling price of the company’s product is $24 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The... The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal... The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 12,300 13,300 15,300 14,300 The selling price of the company’s product is $22 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning... The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal... The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 12,300 13,300 15,300 14,300 The selling price of the company’s product is $22 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning... Evergreen Corporation is preparing the master budget for the third quarter ending March 31, 2009.  It sells... Evergreen Corporation is preparing the master budget for the third quarter ending March 31, 2009.  It sells a single product for $20 a unit.  Sales are 25% cash and 75% credit.  The credit sales are collected 30% in the month of the sale and the remaining 70% is collected in the next month.  No credit sales occurred in December 2008. The December 31 inventory of finished goods is 15,000 units and projected sales are 20,000, 55000, 65,000, 75,000, and 85,000 units for the first  months... The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal... The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 11,700 12,700 14,700 13,700 The selling price of the company’s product is $16 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning... ADVERTISEMENT Need Online Homework Help? Get Answers For Free Most questions answered within 1 hours. Ask a Question ADVERTISEMENT Active Questions Persuade the mayor why the public health issue you selected should be the second priority focus... asked 7 minutes ago In this problem, you will write an implementation of BubbleSort. Your function should take in a... asked 9 minutes ago Identify how information technology differs from information systems. You can buy information technology, but not information... asked 30 minutes ago Having below tables: create table Student(sid char(10) primary key, sname varchar(20) not null, gpa float, major... asked 35 minutes ago What is the slope of the line represented by: 1x + 36y = 840 asked 45 minutes ago dR/dt = −aR + bJ, dJ/dt = bR − aJ (a) What is the story this... asked 58 minutes ago The Great Vowel shift affected A. all vowels B. long vowels only C. short vowels only... asked 1 hour ago A 15.0 M NH3(aq) solution has a density of 0.900 g mL calculate molality asked 1 hour ago Python Invent your own function that does some useful computation of your choosing. Do not copy... asked 1 hour ago Follow the huffman algorithm & create a tree of your own, based on the character frequencies... asked 1 hour ago Prove that Z2 × Z2 × Z2 does not have any subgroup that is isomorphic to... asked 1 hour ago Present a real world example or from a journal paper that entails a time series technique.... asked 1 hour ago About Contact Terms of Use Privacy Policy Academic Honesty Policy Homework Answer Scanner App Report DMCA © 2022 JustAAA   user contributions licensed under cc by-sa 4.0