PYTHON

Falling Distance

When an object is falling because of gravity, the following formula can be used to determine the distance the object falls in a specific time period:

d = ½ gt²

The variables in the formula are as follows:

d is the distance in meters

g is 9.8 (the gravitational constant)

t is the amount of time in seconds the object has been falling

Your program will calculate the distance in meters based on the object’s falling distance.

Modularity: Your program should contain 2 functions:

main – will call the falling_distance function in a loop, passing it the values 1 – 10 as arguments (seconds the object has been falling).   It will display the returned distance.

falling_distance – will be passed one parameter which is the time in seconds the object has been falling and will calculate and return the distance in meters.    falling_distance should be stored in a separate file (module) called distance.py   You will import distance before your main function in your original program file.

Input Validation: None needed

Output: Should look like this:

Time     Falling Distance

-----------------------------

1          4.90

2          19.60

3          44.10

4          78.40

5          122.50

6          176.40

7          240.10

8          313.60

9          396.90

10        490.00

Constellation Brands has a 45 day collection period. Sales for the next four quarters are estimated at $8,400, $8,800, $8,200, and $9,000, respectively, starting with the first quarter of the year. Given this information, which one of the following statements is correct? Assume a 360 day year.

1. Prepare a quarterly schedule of cash receipts budget for PEPSI Company for the year ended December 31, 2021, including the following schedules:
   1. Sales Budget (ALREADY DONE) & Schedule of Cash Receipts (NEED HELP WITH THIS)

Relevant Info

1. Dougs sales forecast consisted of these few lines:
2. For the year ended December 31, 2020: 26,000 units at $290.00 eac
3. For the year ended December 31, 2021: 30,000 units at $290.00 each
4. For the year ended December 31, 2022: 33,000 units at $290.00 each

History has shown that sales are seasonal, with 55% of sales occurring in the second quarter, 20% in the third quarter, 15% in the first quarter, and the remaining 10% in the last quarter.

Sales are on a cash and credit basis, with 40% collected in cash. 60% of Credit sales are collected during the quarter of the sale, and 36% of credit sales are collected in the following quarter. The remainder are uncollectible.

Will provide more info if needed. Thanks

The Bandit’s Beagle Company produces wood dog houses that sell for $400 each. Budgeted sales for the first four months are as follows:

Month                        Budgeted Sales (units)

January                       1,000

February                            1,500

March                                2,500

April                                  2,000

Each dog house requires 20 square feet of oak at a cost of $10 per square foot. The company wants to maintain an inventory of dog houses equal to 10% of the following month’s sales. Inventory on January 1 consisted of 80 dog houses.

The company wants to maintain an inventory of oak equal to 20% of next month’s needs. Materials inventory on January 1 consisted of 11,000 square feet of oak. The company estimates an inventory of oak on hand at the end of March to equal 8,000 square feet.

Each dog house requires 5 hours of direct labor at a cost of $8.00 per hour. Variable manufacturing overhead is budgeted at $2 per direct labor hour.

Monthly fixed overhead consists of the following:

       Supervisors’ salaries                $ 6,000

       Insurance                           $ 2,000

       Depreciation on factory equipment $     500

       Depreciation on production facility $10,000

              Total                           $18,500

The company expects 60% of the sales of each month will be collected in that month, with 35% collected in the following month. Five percent of all sales are uncollectible and written off in the following month.

The accounts receivable balance at the beginning of the year is $200,000, which is 40% of last year’s December sales of $500,000.

The company normally pays for 70% of its purchases in the month of purchase. The remaining 30% is paid in the following month.

Accounts payable at the beginning of the year is $54,000, which is 30% if December purchases of $180,000.

Assume variable selling costs equal 5% of sales and are paid in the month following the sale. Fixed Selling, general and administrative costs are $50,000 and, except for $10,000 of depreciation, are paid in the month incurred. Estimated tax payments equal 40% of estimated income for the quarter are made at the end of each quarter.

The company attempts to maintain a cash balance of $100,000 at all times. Any excess is invested in marketable securities of $10,000 denominations earning an 8% return.

Any deficiencies are covered by borrowing from a local bank at 10% interest.

The cash balance at the beginning of the year is $105,000.

Required:

Prepare a sales budget in dollars for each month and in total for the first quarter of the year.  

Prepare a production budget in units for each month and in total for the first quarter.

Prepare a purchases budget in dollars for direct materials for each month and in total for the first quarter.

Prepare a direct labor budget for each month and in total for the first quarter.

Prepare a manufacturing overhead budget for each month and in total for the first quarter.

Prepare a schedule of cash collections on accounts receivable for each month and in total for the first quarter.

Prepare a schedule of cash payments on accounts payable for each month and in total for the first quarter.

Prepare a pro-forma income statement for each month and in total for the first quarter.

D10.1 [Analyzing real GDP over the business cycle] Go to the Web site of the Federal Reserve Bank of St. Louis (FRED) (research.stlouisfed.org/fred2/). a. Find the values for the most recent quarter for the following three variables: (1) Nominal Gross Domestic Product (GDP), (2) Real Gross Domestic Product (GDPC1), and (3) Real Potential Gross Domestic Product (GDPPOT). b. Using the data from part (a), calculate the GDP Price Deflator for the most recent quarter. c. Calculate for this quarter the percentage difference between real GDP and potential GDP. d. Using Figure 10.2 on page 322, describe the relationship between real GDP and potential GDP over the past 10 years.

Milo-Freeze Company manufactures and sells a product that has seasonal variations in demand, with peak sales coming in the third quarter. The following information concerns operations for Year 2- the coming year- and for the first two quarters of Year 3: a) The company’s single product sells for $10 per unit. Budgeted sales in units for the next six quarters are as follows: Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000 b) Sales are collected in the following pattern: 75% in the quarter the sales are made, and the remaining 25% in the following quarter. On January 1, Year 2, the company’s balance sheet showed $65,000 in accounts receivable, all of which will be collected by the end of first quarter. Bad debts are negligible and can be ignored. c) The company desires an ending inventory of finished units on hand at the end of each quarter equal to 30% of the budgeted sales for the next quarter. On December 31, Year 1, the company had 12,000 units on hand. d) Six pounds of raw materials are required to complete one unit of product. The company requires an ending inventory of raw materials on hand at the end of each quarter equal to 10% of the production needs of the following quarter. On December 31, Year 1, the company had 23,000 pounds of raw materials on hand. e) The raw material costs $0.80 per pound. Purchases of raw material are paid for in the following pattern: 60% paid in the quarter the purchases are made, and the remaining 40% paid in the following quarter. On January 1, Year 2, the company’s balance sheet showed $81,500 in accounts payable for raw material purchases, all of which will be paid for in the first quarter of the year.

Prepare the following budgets and schedules for the year, showing both quarterly and total figures:

1. A sales budget.
2. A cash collections budget.
3. A production budget.
4. A direct materials budget.
5. Cash payments for purchases of materials schedule.

She believes the company’s sales during the first quarter of 20x1 will increase by 10 percent each month over the previous month’s sales. Then Wilcox expects sales to remain constant for several months. Intercoastal’s projected balance sheet as of December 31, 20x0, is as follows: Cash $ 40,000 Accounts receivable 315,000 Marketable securities 25,000 Inventory 192,500 Buildings and equipment (net of accumulated depreciation) 549,000 Total assets $ 1,121,500 Accounts payable $ 220,500 Bond interest payable 6,250 Property taxes payable 6,000 Bonds payable (10%; due in 20x6) 150,000 Common stock 500,000 Retained earnings 238,750 Total liabilities and stockholders’ equity $ 1,121,500 Jack Hanson, the assistant controller, is now preparing a monthly budget for the first quarter of 20x1. In the process, the following information has been accumulated: Projected sales for December of 20x0 are $500,000. Credit sales typically are 70 percent of total sales. Intercoastal’s credit experience indicates that 10 percent of the credit sales are collected during the month of sale, and the remainder are collected during the following month. Intercoastal’s cost of goods sold generally runs at 70 percent of sales. Inventory is purchased on account, and 40 percent of each month’s purchases are paid during the month of purchase. The remainder is paid during the following month. In order to have adequate stocks of inventory on hand, the firm attempts to have inventory at the end of each month equal to half of the next month’s projected cost of goods sold. Hanson has estimated that Intercoastal’s other monthly expenses will be as follows: Sales salaries $ 35,000 Advertising and promotion 16,000 Administrative salaries 35,000 Depreciation 25,000 Interest on bonds 1,250 Property taxes 1,500 In addition, sales commissions run at the rate of 2 percent of sales. Intercoastal’s president, Davies-Lowry, has indicated that the firm should invest $105,000 in an automated inventory-handling system to control the movement of inventory in the firm’s warehouse just after the new year begins. These equipment purchases will be financed primarily from the firm’s cash and marketable securities. However, Davies-Lowry believes that Intercoastal needs to keep a minimum cash balance of $40,000. If necessary, the remainder of the equipment purchases will be financed using short-term credit from a local bank. The minimum period for such a loan is three months. Hanson believes short-term interest rates will be 10 percent per year at the time of the equipment purchases. If a loan is necessary, Davies-Lowry has decided it should be paid off by the end of the first quarter if possible. Intercoastal’s board of directors has indicated an intention to declare and pay dividends of $50,000 on the last day of each quarter. The interest on any short-term borrowing will be paid when the loan is repaid. Interest on Intercoastal’s bonds is paid semiannually on January 31 and July 31 for the preceding six-month period. Property taxes are paid semiannually on February 28 and August 31 for the preceding six-month period. Required: Prepare Intercoastal Electronics Company’s master budget for the first quarter of 20x1 by completing the following schedules and statements. 5. Complete the first three lines of the summary cash budget. Then do the analysis of short-term financing needs in requirement 6. Then finish requirement 5.

Samantha wants to set up a fund which will provide in perpetuity a scholarship of $2,600

to a deserving student at the end of each year with the first payment being made one year

from today . Find the amount Betty should deposit today into the fund to provide for this

scholarship if the interest rate is 3.8% compounded quarterly.

Milton Inc. has prepared the following first quarter sales forecast:

January 370 000 units
February 485 000 units
March 545 000 units

Each unit sells for $4.50.

The sales budget for the first quarter is: