Question
A. Sales/CollectionSales unit in the fourth quarter of 2020 will be 2500 units and is expected to increase by 500 units over each quarter in
A. Sales/CollectionSales unit in the fourth quarter of 2020 will be 2500 units and is expected to increase by 500 units over each quarter in 2021. Selling price is $60 per unit. All sales are on account. Management expects future sales collection to follow past experiences. Customers pay 60% in the quarter of sales and 40% in the quarter following sales. Accounts receivable for December 31, 2020 is expected to be $60,000.B. ProductionTo reduce the risk of a stock-out or idle time, D'Unique Co. has maintained an ending inventory policy of 20% of the following quarter's sales unit.C. Direct material Each bottle of hair growth oil requires four ounces of liquid which cost $3.50 per ounce. The company wants to maintain an ending inventory of raw materials equal to 10% of the next quarter's production requirements. Ending inventory of raw material for the fourth quarter of 2020 will be 1,520 ounces. Payments to suppliers for the purchase of direct material are done in two tranches - 70% in the quarter of purchase and 30% the quarter following purchase. Accounts payable of $10,600 at December 31, 2020, is expected to be paid in full in the first quarter of 2021.D. Direct LabourAs the company is still labour intensive, one bottle takes an employee one hour to package. The standard wages rate of direct labour is $10.00 per hour.E. Manufacturing OverheadD'Unique Company manufacturing overheads is absorbed on the basis of direct labour hours. The following variable cost rates are: 1. Indirect materials $1.002. Indirect labor $1.403. Utilities $0.404. Maintenance $0.20D'Unique also recognizes the following fixed manufacturing overheads costs per quarter:Fixed Overhead $Supervisors salary 20,000Depreciation 3,800Property tax 9,000maintenance 5,700F. Selling and Administrative ExpenseVariable selling and administrative expense rates per unit of sales are: sales commissions $3.00 and freight-out $1.00. Fixed expenses for each quarter are:Fixed Costs $Advertising 6,500sales salaries 15,000office salaries 4,000depreciation 3,500property taxes and insurance 2,500G. Other expenses1. Management plans to purchase a delivery truck in the first quarter for $100,000 cash. This will be a loan from the bank in the first quarter of 2021. Interest rate on the loan is 4% per annum.2. D'Unique makes equal quarterly payments of its estimated annual income taxes of $36,000.H. Other informationThe company is expected to have a cash balance of 65,000 on January 1, 2021. The company wants to maintain a minimum cash balance of $15,000. Loan and interest payments are made in multiples of 10,000 in the earliest quarter in which there is sufficient cash (that is, when the cash on hand exceeds the $15,000 minimum required balance).RequiredPrepare the following budgets:
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