Answered step by step
Verified Expert Solution
Question
1 Approved Answer
P3. Ashley Company manufactures and sells two types of control devices - Blue Sky and Blossom. A portion of each month's sales is collected
P3. Ashley Company manufactures and sells two types of control devices - Blue Sky and Blossom. A portion of each month's sales is collected in the month of sale, and the rest is collected in the following month. Production requires two types of materials - Material A and Material B. A portion of each month's purchase of raw materials is paid in the month of purchase, and the rest is paid in the following month. All manufacturing, selling and administrative expenses are paid in cash during the month incurred. As reflected on the Excel sheet, specific cash dividends and capital expenditures for machines are planned. Minimum required cash balance at the end of each month is $40,000. If necessary, the company will borrow cash from a bank. The borrowing will be in multiples of $1,000 and will bear interest at 2% per month. All borrowing will take place at the beginning of the month. A month's interest will be paid in cash at the end of month. Any cash available will be used to pay off the outstanding debt in multiples of $1,000 at the end of each month. The amount of borrowing, interest, and payoff must be computed manually and entered in the data section in the space provided and highlighted in yellow. The company's policy and plan for the first three months of upcoming year is summarized on Excel file in the tab entitled "Budgeting". The accountant of company, after preparing sales budget, production budget, and RM purchases budget, has taken a vacation to go to Hawaii. You have been hired to prepare the Cash Budget of the master budget for the company. The company management plans to simulate the budgeted numbers for various scenarios. Thus, the budgets on the Excel should be created in a manner that allows for simulation (i.e., by using only formulas inside of each cell of the budgets). Budget lines must have appropriate, clear, complete, and understandable headings with necessary formatting of the cells.
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