Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Master Budget Case Study As part of the continued advancement of technology, a drone camera market has emerged in recent years. The drone camera market
Master Budget Case StudyAs part of the continued advancement of technology, a drone camera market has emerged in recent years. The drone camera market has been growing as more photography enthusiasts have begun adopted this hightech approach to capturing still images and video using remotely controlled devices. Eager to capture a share of this growing market,CamDroneentered the market in early CamDrone manufactures camera drones, selling primarily to retailers.CamDrone is pleased with its financial performance over its first few years of operations, optimistic to achieve continued financial success. For planning and control purposes the company utilizes a monthly master budget, which is usually developed at least three months in advance of the budget year. The company has a fiscal year ending December It is now Sept You have been asked to prepare the Master Budget for the year ending December Based on your discussions with the various departments throughout the company, you have collected the following relevant information for preparing the budget:Sales The marketing department is forecasting the following annual sales: For the year ended December : units at $ each For the year ended December : units at $ each For the year ended December : units at $ eachExpected sales for the year ended December were based on actual sales to date and budgeted sales for the duration of the year. Peak months for sales generally correspond with summer weather and giftgiving holidays. History shows that January is the slowest month, with only of annual sales, followed closely behind by FebApril with of annual sales for each month. Sales spike during summer months with May, June, July, and August contributing and of annual sales respectively. With the backtoschool focus in September, there is a significant dip in camera drone sales to of annual sales. As Christmas shopping picks up momentum, winter sales increase to in October, in November, and then peak at in December. This pattern of sales is not expected to change in the next two years.Manufacturing Costs and Inventory Each camera drones spends a total of hours in production Due to the highly technical nature of CamDrones manufacturing process, CamDrones direct labour rate has averaged $ per hour for This rate already includes the employers portion of employee benefits. A new collective agreement is being negotiated, with a pay increase anticipated effective January Each CamDrone requires kg of direct materials. During the average cost of direct materials was $kg The supplier of the direct materials tends to be somewhat erratic, so CamDrone finds it necessary to maintain a direct materials inventory balance equal to of the following months production needs as a precaution against stockouts. Due to the similarity of the equipment in each of the production stages and the companys concentration on a single product, manufacturing overhead is allocated based on volume ie the units produced The variable manufacturing overhead rate for is $unit consisting of:Plant & Equipment Maintenance$ UtilitiesIndirect MaterialsOther$ The fixed manufacturing overhead costs for are as follows:Supervisors salaryAmortization of Plant & Equipment$ InsuranceTraining & DevelopmentProperty and Business TaxesOther$ Amortization is calculated using the straightline method, with no amortization calculated in the year capital assets are acquired. Aside from amortization, all other manufacturing costs are expected to increase by in due to inflation. From previous experience, management has determined that an ending finished goods inventory equal to of the next months sales is required to efficiently meet customer demands.Collections Pattern Sales are on a cash and credit basis, with collected during the month of the sale, the following month, and the month thereafter. There are no early payment discounts for customers. Bad debt expense amounts considered uncollectible account for of sales. Based on the collection pattern described above, accounts payable as at end of business day on December is projected to be $ arising from the following estimates:Sales November $Sales December $Payments Pattern CamDrone pays for of a months purchases of direct materials in the month of purchase, in the following month and the remaining two months after the month of purchase. There are no early payment discounts offered by suppliers. Based on the payment pattern described above, accounts payable as at end of business day on December is projected to be $ arising from the following estimates:Direct Material Purchases November $Direct Material Purchases December $ All payroll costs are paid in the period in which they are incurred. The property and business taxes, paid at the beginning of July each year, apply to the following month period. Any increases for inflation on property and business taxes do not take effect until the beginning of July each year. Annual insurance premiums, paid at the beginning of April each year, apply to the following month period. Any increases for inflation on insurance premiums do not take effect until the beginning of April each year. Fixed manufacturing overhead costs are incurred evenly over the year and cash related amounts are paid as incurred. Selling and administrative expenses are paid in the month in which they occur.Other Anticipating a significant increase in customer demand and market share over the next few years, CamDrone is planning a significant expansion involving acquiringadditional manufacturing equipment for $ cash. Half of this amount is to be paid to the equipment supplier in July with the remainder to be paid in October Selling and administrative expenses are known to be a mixed cost; however, there is a lot of uncertainty about the portion that is fixed. Based on prior year experience:Lowest level of monthly sales: units... Total Operating Expenses: $Highest level of monthly sales: units... Total Operating Expenses: $ excluding bad debts and amounts described belowThese expenses are expected to increase by in due to inflation. To secure and grow its market share, CamDrone is planning to operate popup kiosks in various local retail centers during peak sales months MayAug, NovDec commencing Nov CamDrone is budgeting $ per month including all related fees and taxes payable at the beginning of each month, to setup and operate these kiosks. The cost to setup and operate popup kiosks will be in addition to the normal selling and administrative expenses described above and is not expected to increase during Income tax expense is estimated to be of net income. CamDrone makes monthly income tax installment payments of $ and pays all outstanding income taxes in excess of installment payments in March of the following year. As such, any outstanding income tax balance for the year ended December it will be paid in March An arrangement has been made with the local bank that if CamDrone maintains a minimum balance of $ in their bank account, they will be given a line of credit at a preferred rate of per annum per month All borrowing is considered to happen on the first day of the month, repayments are on the last day of the month. All borrowings and repayments from the bank should be in multiples of$ and interest must be paid at the end of each month. Interest is calculated on the balance at the beginning of the month, which includes any amounts borrowed that month. CamDrone has a policy of paying dividends at the end of each quarter. The President tells you that the Board of Directors is planning on declaring dividends as follows:March $June $September $December $Dividends are paid in the month they are declared. The company is forecasting the following balances as at the end of business day on December :AssetsCash$ Accounts ReceivableInventory: Direct MaterialsInventory: Finished GoodsPrepaid Property and Business TaxesPrepaid InsuranceCapital Assets netTotal Assets$Liabilities and Shareholders EquityAccounts Payable$ Income Taxes PayableCapital StockRetained EarningsTotal Liabilities and Shareholders Equity$Required:Prepare a monthly master budget for CamDrone for the year ending December whow your answers for the following schedules only. direct materials budget
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