Questions
Bohemian Interior Design has projected the following quarterly sales. The accounts receivable at the beginning of...

Bohemian Interior Design has projected the following quarterly sales. The accounts receivable at the beginning of the year is $1,030,000 and the collection period is 58 days. What are collections for the first quarter and second quarters? (5 points) Q1 Q2 Q3 Q4 Sales $ 1,705 ,000 $ 1,765 ,000 $ 2,115 ,000 $ 2,135 ,000

In: Finance

Bohemian Interior Design has projected the following quarterly sales. The accounts receivable at the beginning of...

  1. Bohemian Interior Design has projected the following quarterly sales. The accounts receivable at the beginning of the year is $1,030,000 and the collection period is 58 days. What are collections for the first quarter and second quarters? (5 points)

Q1

Q2

Q3

Q4

Sales

$

1,705

,000

$

1,765

,000

$

2,115

,000

$

2,135

,000

In: Finance

A spherical raindrop 2.7 mm in diameter falls through a vertical distance of 5000 m. Take...

A spherical raindrop 2.7 mm in diameter falls through a vertical distance of 5000 m. Take the cross-sectional area of a raindrop = πr2, drag coefficient = 0.45, density of water to be 1000 kg/m3,and density of air to be 1.2 kg/m3.

(a) Calculate the speed a spherical raindrop would achieve falling from 5000 m in the absence of air drag.
313.04 m/s (correct)

(b) What would its speed be at the end of 5000 m when there is air drag? (Note that the raindrop will reach terminal velocity after falling about 30 m.)
  
_______ m/s

In: Physics

Use Excel to calculate the values to fill in the empty boxes. Feel free to add...

Use Excel to calculate the values to fill in the empty boxes. Feel free to add additional tables and calculations as
needed. Please use the assignment 1 discussion board to ask questions. Once completed, save this file and
upload it in Canvas.
Historical Demand Data 2012 to 2016:
The table reproduced below is the demand data for a company (aggregated) for the previous five years.
2012 2013 2014 2015 2016
Q1 11632 15034 16117 15565 16470
Q2 22509 26824 24169 20151 42858
Q3 21646 13314 14505 13392 19278
Q4 11355 10698 11176 10613 13934
Annual Demand 67,142 65,870 65,967 59,721 92,540
Average Quarterly Demand 16,785.50 16,467.50 16,491.75 14,930.25 23,135.00
Forecasting Using Moving Average Methods
Using the historical demand data above, you are to determine the total annual demand forecast for 2016 and 2017 using:
Ø the three-period moving average forecasting method
Ø the three-period weighted moving average method with weights of .6, .3, and .1 use .6 for most recent period (Use .6 for most recent period)
Enter your forecast results in the following tables.
2016 Annual Forecast Using a Moving Average 2016 Annual Forecast Using a Weighted Moving Average 2017 Annual Forecast Using a Moving Average 2017 Annual Forecast Using a Weighted Moving Average
63,852.67 62209.7 72742.67 80037
Calculate a Time Series Linear equation using the all of the above demand data:
Using the historical demand data for 2012 through 2016, create a linear equation with the year as the independent variable and the annual volume as the dependent variable.
(Excel can be quite useful here, consider the Slope and Intercept functions)
Enter your linear equation in text from here:     y = a + bX
Calculated 2017 Annual Forecast from Linear Equation:   x=2017
Forecasting Using an Exponential Smoothing Method and Seasonal Factors:
Using the historical demand data for 2012 through 2016 given on the first page you are to:
Ø Using the exponential smoothing forecasting method with an alpha value of 0.7, forecast the total annual demand for 2017. Start your forecast calculations with the total annual demand for 2012 and a starting forecast for 2012 that is the  
    same as the 2012 total annual demand. After you have the annual forecast for 2012, use the average seasonal factors determined in the first part above to calculate the quarterly demand forecasts for 2017.
Ø Determine the average seasonal factors for each quarter. Remember that you will first need to calculate the total annual demand and then average quarterly demand for each year of data as shown in lecture.
Ø Determine the MAD, CFE, and MAPE errors between the annual forecast values using exponential smoothing for 2013 to 2016 and the actual annual demand data for 2013 to 2016. Enter the values in response to the three questions below.
2012 2013 2014 2015 2016 2017
Actual Annual Demand 67,142 65,870 65,967 59,721 92,540 alpha= 0.7
Forecasted Annual Demand 67,142 67142 66251.6 66052.38 61620.414
Forecast Error -1,272 -285 -6,331 30,920
Values Seasonal Factor for each Quarter 2017 Quarterly Forecast Index 2012 2013 2014 2015 2016
Quarter 1 0.89 Q1 0.69 0.90 0.96 0.93 0.98
Quarter 2 1.63 Q2 1.34 1.60 1.44 1.20 2.55
Quarter 3 0.98 Q3 1.29 0.79 0.86 0.80 1.15
Quarter 4 0.69 Q4 0.68 0.64 0.67 0.63 0.83
Totals 4.19
What is the MAD value for the exponential smoothing forecast? Answer =
What is the CFE value for the exponential smoothing forecast? Answer =
What is the MAPE value for the exponential smoothing forecast? Answer =
Forecasting using trend with regression:
Calculate forecasts for 2017, 2016 and 2015 using a linear regression of the previous three actual demand values.  
(Hint: You will need to calculate three different linear equations.)
2012 2013 2014 2015 2016 2017
Actual Annual Demand 67,142 65,870 65,967 59,721 92,540 slope -587.5
Forecasted Annual Demand 67,142 67,142 66,252 66,052 61,620 intercept
Forecast Error -6,331 30,920
What is the MAD value for the trend with regression forecast? Answer =
What is the CFE value for the trend with regression forecast? Answer =
What is the MAPE value for the trend with regression forecast? Answer =

In: Operations Management

Monthly Sales Tax A retail company must file a monthly sales tax report listing the total...

  1. Monthly Sales Tax

    A retail company must file a monthly sales tax report listing the total sales for the month, and the amount of state and county sales tax collected. The state sales tax rate is 5 percent and the county sales tax rate is 2.5 percent. Write a Python program with function(s) that asks the user to enter the total sales for the month. Make sure that you do not allow user to enter negative values for the total sales (that is validate with a loop). From the entered total sales amount, your program should calculate and display the following:

    • The amount of county sales tax
    • The amount of state sales tax

    • The total sales tax (county plus state)

    • Note: Your program should have multiple functions.
  2. 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:

    [Math Processing Error]distance=12gt2

    The variables in the formula are as follows: d is the distance in meters, g is 9.8, and t is the amount of time, in seconds, that the object has been falling.

    Write a function named falling_distance (in Python) that accepts an object’s falling time (in seconds) as an argument. The function should return the distance, in meters, that the object has fallen during that time interval. Write a Python program (main function) that calls the falling_distance function in a loop that passes the values 1 through 10 as arguments and displays the return value for each iteration.

In: Computer Science

the following the average marginal propensity to consume (MPC) is c1 = .52. They then looked...

the following the average marginal propensity to consume (MPC) is c1 = .52.

They then looked at how different groups had different marginal propensities to consume. In particular:

  • For Group 1 of Italians, their MPC is c1 = .3
  • For Group 2 of Italians, their MPC is c1 = .65

Now, take the following hypothetical situation about the Italian economy:

M = X = 0
G = 500, Tp=500
C = 1000 + c1(Y-Tp)
I = 200

Round to two decimal places in answers below:

  1. First let’s imagine all Italians have the average MPC of c1 = .52
    1. What is the equilibrium level income? 3000
    2. If the gov’t increases spending by 200, what is the new equilibrium level of income? 3416.67
    3. What is the multiplier on government spending? 2.08
    4. If government spending stays at 500, and instead they lower personal taxes by 200, why is the new equilibrium level of income? 3216.67
    5. What is the multiplier on the tax reduction?-1.08
    6. Which multiplier is larger? multiplier on govt spending is larger
    7. Why are they different? portion of increase govt spending is consumed resulting in lower taxes?

  1. Now, let’s look at the effect of difference in MPC.
    1. Fill out the following table (your answer for all Italians should come from question 1)

Effect of Difference in MPC

Marginal propensity to consume

Multiplier on government spending

All Italians

.52

2.08

Group 1

.3

1.43

Group 2

.65

2.86
  1. Discuss the differences in multipliers. In words (not math!), how does the MPC relate to the multiplier?
  2. Group 1 and Group 2 are two mutually exclusive collections of people in the Italian economy that have different consumption habits (this could be based on geography, age, income level, education, et) Make an educated guess about who belongs to each group. Then explain your reasoning.

Need help with G and then B and C

In: Economics

If an average-sized man jumps from an airplane with an open parachute, his downward velocity t...

If an average-sized man jumps from an airplane with an open parachute, his downward velocity t seconds into the fall is V(t) = 20 ( 1-0.2t ) feet per second. Explain how the velocity increases with time.Include in your explanation a comparison of more than one calculated average rate of change (ARC). Find the terminal velocity. Find the time it takes to reach 99% of terminal velocity. Compare your answer in part C with the time it took to reach 99% of terminal velocity on the 2.1 Additional Worksheet part d for a free falling skydiver. On the basis of that information, which would you expect to reach 99% of terminal velocity first, a feather or a cannonball? Explain your reasoning.

In: Physics

Between China, India, and United Kingdom which country would be the most considered to expand a...

Between China, India, and United Kingdom which country would be the most considered to expand a bussiness in that exports goods to the U.S?

In: Operations Management

Suppose that Stillwater Designs has two classes of distributors: JIT distributors and non-JIT distributors. The JIT...

Suppose that Stillwater Designs has two classes of distributors: JIT distributors and non-JIT distributors. The JIT distributor places small, frequent orders, and the non-JIT distributor tends to place larger, less frequent orders. Both types of distributors are buying the same product. Stillwater Designs provides the following information about customer-related activities and costs for the most recent quarter:

JIT
Distributors
Non-JIT
Distributors
Sales orders 900 90
Sales calls 70 70
Service calls 350 175
Average order size 650 6,500
Manufacturing cost/unit $125 $125
Customer costs:
  Processing sales orders $3,180,000
  Selling goods 1,120,000
  Servicing goods 1,050,000
    Total $5,350,000

Required:

1. Calculate the total revenues per distributor category, and assign the customer costs to each distributor type by using revenues as the allocation base. Selling price for one unit is $150. Round calculations to the nearest dollar.

JIT Non-JIT
Sales (in units)
Sales $ $
Allocation $ $

2. Conceptual Connection: Calculate the customer cost per distributor type using activity-based cost assignments. Round the interim calculations to the nearest dollar.

JIT Non-JIT
Ordering costs $ $
Selling costs $ $
Service costs $ $
Total $ $

For non JIT distributors by how much can the price be decreased without affecting customer profitability? Round your answer to the nearest cent.

$ per unit

In: Accounting

The production department of Zan Corporation has submitted the following forecast of units to be produced...

The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year:

1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
Units to be produced 8,000 11,000 10,000 9,000

In addition, 12,000 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $5,400.

Each unit requires 6 grams of raw material that costs $1.80 per gram. Management desires to end each quarter with an inventory of raw materials equal to 25% of the following quarter’s production needs. The desired ending inventory for the 4th Quarter is 5,000 grams. Management plans to pay for 60% of raw material purchases in the quarter acquired and 40% in the following quarter. Each unit requires 0.40 direct labor-hours and direct laborers are paid $14.50 per hour.

Required:

1.&2. Calculate the estimated grams of raw material that need to be purchased and the cost of raw material purchases for each quarter and for the year as a whole.

3. Calculate the expected cash disbursements for purchases of materials for each quarter and for the year as a whole.

4. Calculate the estimated direct labor cost for each quarter and for the year as a whole. Assume that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the estimated number of units produced.

1st 2nd 3rd 4th
Quarter Quarter Quarter Quarter Year
Estimated grams of raw material to be purchased
Cost of raw materials to be purchased

Calculate the expected cash disbursements for purchases of materials for each quarter and for the year as a whole.

1st 2nd 3rd 4th
Quarter Quarter Quarter Quarter Year
Total cash disbursements for materials
1st 2nd 3rd 4th
Quarter Quarter Quarter Quarter Year
Total direct labor cost

In: Accounting