[Answered] Contact Us for this Answer +1 323-412-5597 / support@studentscoursework.com Master Budget Cash Budget and Budgeted Income StatementAfter two years study at UCW you finally graduate and start a job as Junior accountant at Bigdream Inc. Your manager is responsible for the nationwide distribution of creator design sets. Because of the new social media influence among current generation the company has grown rapidly and the prompt growth forces the management team to improve their efficiency and manage their production effectively. You have just been given responsibility for all planning and budgeting of the entire lighting set division. Today is your first day you have just given an assignment to prepare master budget for the manager who needs to present the budget and discuss the financial objectives with the shareholders tomorrow. During your job interview you clearly stated that you gained managerial accounting knowledge and hand on experience during your MBA study. Your first assignment is to prepare a master budget for the next fiscal year starting January 1 2021. Your co-work has left a pile of files on your desk including the past sale records product information manufacture schedule and supplier pricing list. Now you realized that you should have pay more attention during the lecture. Now you don’t know where to start. Fortunately you remember that you still kept a copy spreadsheet of the master budget template in your laptop from the accounting course. Note: The company desires a minimum ending cash balance each month on $85000. The Bigdream products are sold to retailers for $129 each and the sales have been in demand due to the Covid-19. However the marketing department has been conservative toward the end of the year due market saturation. The marketing department has just sent you their forecasted quarter sales and marketing budget. Ending finished goods inventories are supposed to be equal to 20% of the next month’s sales in units. Bigdream currently does its own assembly production in house. Each unit consists of 3LED panels and the cost of each is $15. 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 Bigdream 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. Below is a display of the Bigdream division monthly manufacture overhead and selling and administrative expenses: Manufacture OverheadVariable: Indirect labour $5 per labour hour Indirect Materials $2.00 per labour hour Fixed: Wages and Salaries$2000 per month Utilities $1500 per month Insurance $2000 per month Depreciation $2000 per month Selling and Administrative Variable:Sales Commissions $5 per unit Fixed (Monthly):Wages and Salaries$22000 Utilities $6000 Insurance $1200 Depreciation $1500 Miscellaneous $3000 Labour Manufacture Overhead and Selling and Administrative expenses are all paid during the month in cash with the exception of depreciation (of course). Bigdream will make a purchase of a parcel of land during the first quarter of 2021 for $50000 cash. Bigdream’s balance sheet at the end of the fourth quarter is shown below: AssetsCash $35000 Uncollected Accounts receivable in Q4 this year: $200000 Liabilities Accounts payable $85700 An agreement with Bank of the West allows Bigdream to borrow up to a total loan amount of $550000. The interest rate on these loans is 12% annually (pretty high considering market rates) but the interest is not compounded meaning this is simple interest only. Required: 1) Master Budget2) Cash Budget. Show the cash budget by month and in total. 3) Budgeted Income statement

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.

Read more

Free-revision policy

The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.

Read more

Privacy policy

The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.

Read more

Fair-cooperation guarantee

By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency

Order your paper today and save 20% with the discount code HAPPY

X
Open chat
1
You can contact our live agent via WhatsApp! Via + 1 323 412 5597

Feel free to ask questions, clarifications, or discounts available when placing an order.