Please solve the questions below and mention the question number infront of every solution. I put number on the every screenshot.

This is the whole question, there is no additional information.

10:09 PM Mon May 20 : 87% learn-us-east-1-prod-fleet02-xythos.content.blackboardcan.com 1. Internal Operating Schedules Assume you are starting a new business involving the manufacture and sale of a new product. Raw materials costs are $50 per product. Direct labor costs are expected to be $30 per product. You expect to sell each product for $115. You plan to produce 100 products next month and expect to sell 90 products. A. Prepare cost of production, cost of goods sold, and inventories schedules for the first month. (Cells highlighted in yellow) B. During the second month, you plan to produce 120 products but expect sales in the month to be 115 products. Prepare cost of production, cost of goods sold, and inventories schedules for the second month. (Cells highlighted in green) Cost of Production Schedule: Cost Per Unit Month 1 Month 2 Production (# units) Production costs: Raw materials Direct labor Total costs Cost of Goods Sold Schedule: Month 1 Month 2 Sales (units) Costs @ $80 per unit10:10 PM Mon May 20 . . . : 87% learn-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com Statement of Cash Flows Cash from Operating Activities: 2016 Net income + Depreciation -Increase in accounts receivable -Increase in inventories +Increase in accounts payable +Increase in accrued liabilities Net from Operating Activities Cash from Investing Activities: -Increase in gross fixed assets Net from Investing Activities Cash from Financing Activities: + Increase in bank loan + Increase in long-term debt - Cash dividends paid Net from Financing Activities Total net cash increase (decrease) Cash at beginning of period Total net cash increase (decrease) Cash at end of period10:09 PM Mon May 20 . . . : 87% learn-us-east-1-prod-fleet02-xythos.content.blackboardcan.com Inventories Schedule: Month 1 Month 2 Beginning finished goods Production: Raw materials Direct labor Additions (sum of raw materials and direct labor Total (beginning finished goods + additions) 2 Less: Cost of goods sold Ending finished goods Statement of Cash Flows and Cash Burn or Build Cindy and Robert Castillo founded the Castillo Products Company in 2015. The company manufactures components for personal decision assistant (PDA) products and for other hand-held electronic products. Year 2015 proved to be a test of the Castillo Products Company's ability to survive. However, sales increased rapidly in 2016 and the firm reported a net income after taxes of $75,000. Depreciation expenses were $40,000 in 2016. Following are the Castillo Products Company's balance sheets for 2015 and 2016. CASTILLO PRODUCTS COMPANY10:11 PM Mon May 20 . . . : 87% learn-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com G. Show what would happen to the EBDAT breakeven in terms of survival revenues if the cost of producing a cup of yogurt increased to $2.75 but the selling price remained at $4.00 per cup. How would the EBDAT breakeven change if production costs declined to $2.40 per cup when the yogurt selling price remained at $4.00 per cup?2015 2016 Cash $55,000 $20,000 Accounts Receivables 200,000 280,000 Inventories 400,000 500,000 Total Current Assets 655,000 800,000 Gross Fixed Assets 450,000 540,000 Accumulated Depreciation -100,000 -140,000 Net Fixed Assets 350,000 400,000 Total Assets $1,005,000 $1,200,000 Accounts Payable $135,000 $160,000 Accruals 50,000 70,000 Bank Loan 90,000 100,000 Total Current Liabilities 275,000 330,000 Long-Term Debt 300,000 400,000 Common Stock ($.01 par) 150,000 150,000 Additional Paid-in-Capital 200,000 200,000 Retained Earnings 80,000 120,000 Total Liabilities & Equity $1,005,000 _$1,200,000 10:11 PM Mon May 20 eoe SR AA 1l & learn-us-east-1-prod-fleet02-xythos.content.blackboardedn.com 2. MINI CASE: JEN AND LARRY'S FROZEN YOGURT COMPANY In 2016, Jennifer (Jen) Liu and Larry Mestas founded Jen and Larry's Frozen Yogurt Company, which was based on the idea of applying the microbrew or microbatch strategy to the production and sale of frozen yogurt. Jen and Larry began producing small quantities of unique flavors and blends in limited editions. Revenues were $610,000 in 2016 and were estimated at $1.1 million in 2017. Because Jen and Larry were selling premium frozen yogurt containing premium ingredients, each small cup of yogurt sold for $4 and the cost of producing the frozen yogurt averaged $2.50 per cup. Administrative expenses, including Jen's salary and expenses for an accountant and two other administrative staff, were estimated at $185,000 in year 2017. Marketing expenses, largely in the form of behind-the-counter workers, in-store posters, and advertising in local newspapers, were projected to be $200,000 in year 2017. An investment in bricks and mortar was necessary to make and sell the yogurt. Initial specialty equipment and the renovation of an old warehouse building in Lower Downtown (known as LoDo) occurred at the beginning of 2016 and additional equipment needed to make the amount of yogurt forecasted to be sold in 2017 was purchased at the beginning of 2017. As a result, depreciation expenses were expected to be $50,000 in year 2017. Interest expenses were estimated at $15,000 in 2017. The average tax rate was expected to be 25 percent of taxable income. Tip: Use Excel to set up a 2017 income statement based on the information presented in the case. An example is available in the Week 2 folder to get you started. A. How many cups of frozen yogurt would have to be sold in order for the firm to reach its projected revenues of $1.1 million? B. Calculate the dollar amount of EBDAT if Jen and Larry's Frozen Yogurt Company achieves the forecasted $1.1 million in sales for year 2017. What would EBDAT be as a percent of revenues? 10:11 PM Mon May 20 : 87% learn-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com C. Jen and Larry believe that under a worst-case scenario, yogurt revenues would be at the 2016 level of $610,000 even after plans and expenditures were put in place to ramp up revenues in year 2017. What would happen to the venture's EBDAT? D. Jen and Larry also believe that under very optimistic conditions that yogurt revenues could reach $1.5 million in year 2017. Show what would happen to the venture's EBDAT if this were to happen.10:11 PM Mon May 20 . . . : 87% AA learn-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com C + H Free Al Answer Ge... Al Answer Generat... Best Al Homework... Course Hero il, Content B BA 351 Syllabus Su... X B Chapter 4 E. What are the projected 2017 cash fixed costs (i.e. fixed operating and financing costs) for Jen and Larry? What are their projected variable costs at a revenue of $1. 1 million? What is their contribution margin? F. Calculate the EBDAT breakeven point for year 2017 in terms of survival revenues for Jen and Larry's Frozen Yogurt Company. How many cups of frozen yogurt would have to be sold to reach EBDAT breakeven?10:10 PM Mon May 20 eoo & learn-us-east-1-prod-fleet02-xythos.content.blackboardedn.com A. Calculate Castillo's cash flow from operating activities for 2016. B. Calculate Castillo's cash flow from investing activities for 2016. C. Calculate Castillo's cash flow from financing activities for 2016. D. Prepare a formal statement of cash flows for 2016 and identify the major cash outflows that were generated by the Castillo Company. (A template is provided for you on the next page) E. Use your calculation results from Parts A and B above to determine whether Castillo was building or burning cash during 2016 and indicate the dollar amount of the cash build or burn. F. If Castillo had a net cash burn from operating and investing activities in 2016 divide the amount of burn by 12 to calculate an average monthly burn amount. If the 2017 monthly cash burn continues at the 2016 rate, indicate how long in months it will be before the firm runs out of cash if there are no changes in financing activities