Answered step by step
Verified Expert Solution
Question
1 Approved Answer
As part of the continued advancement of technology, a drone camera market has emerged in recent years. The drone camera market has been growing as
As 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 adopting this hightech approach to capturing still images and video using remotely controlled devices. Eager to capture a share of this growing market, CamDrone entered 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 and optimistic about achieving 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 $ each
Expected 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 drone requires a total of hours for 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 for example, the units produced The variable manufacturing overhead rate for is $unit consisting of:
Plant & Equipment Maintenance $
Utilities
Indirect Materials
Other
$
The fixed manufacturing overhead costs for are as follows:
Supervisors salary
Amortization of Plant & Equipment $
Insurance
Training & Development
Property and Business Taxes
Other
$
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 expenses amounts considered uncollectible account for of sales.
Based on the collection pattern described above, accounts payable as at the 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, account
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