Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write down the total fixed MOH expense, including depreciation expense, based on the list you have prepared in the last table. Remember, Total selling and
Write down the total fixed MOH expense, including depreciation expense, based on the list you have prepared in the last table. Remember, Total selling and administrative (Sn'A) expense = Variable Sn'A + Fixed Sn'A Your variable Sn'A expense consists of only two items - delivery expense per unit and packaging cost per unit. Write your estimations about delivery expense per unit and packaging cost per unit in the following table. Also, add the two numbers to calculate total variable Sn'A expense for each unit of product. Your fixed advertising expense consists of only one item - facebook advertising expense. Write your estimation about your monthly facebook advertising expense. This is your total fixed Sn'A expense per month. Calculate your total variable expenses for each unit product by adding the direct material cost per unit, variable MOH rate per unit, and variable Sn'A expense per unit of product. . Calculate your selling price per unit by charging a 200% mark-up on per unit variable expense. Now, we will make some estimations about the number of units of product your business expects to sell over the next 12 months. Fill out the following table about sales estimates. Month Estimated Units of Product Sold October November December January February March April May June July August September . Assume all sales will be 75% on cash and 25% on credit. you will collect your credit in the month following the month of sale. . Since you are going to sell a food item, no ending inventory of finished goods will be maintained. Each unit will be manufactured after an order is received. All purchases for all direct materials are made 60% in cash and 40% on credit to be paid equally over two months next to month of sales. . You want to draw dividend of BDT 20,000 every month the sole owner of your business. [This your dividend, you will not use this money for operating your business.) . At the end of each month you want to have at least BDT 30,000 cash available for operating your business. You will start the business with a cash investment of BDT 500,000. You can borrow up to BDT 200,000 from your best friend to invest in your business. You will repay the borrowed amount, if you have cash available in excess of your minimum cash requirement. Requirements: Based on the assumptions you have formed above, prepare a Master Budget consisting of the following components in the Google Sheet attached to this assignment. 1. Sales Budget [No schedule of cash collection will be needed as all sales are on cash.] 2. Direct Material Budget(s) [Make a separate budget for each direct material. No schedule of cash disbursements for direct material will be necessary as all purchases will be made in cash.] 3. MOH Budget. 4. Sn'A Expense Budget 5. Cash Budget Note: You will not need any production budget since units sold = units produced every month. Thus, the sales estimates you have formed above will also be used as the number of units produced in the Master Budget. Your budget must be prepared as demonstrated in class. First input your assumptions in the Google Sheet, and then prepare a fully linked Master Budget making use of cell referencing and automated formulas for calculations
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