Penn company assembles and sells computer

Assignment Help Financial Accounting

Reference no: EM13950682

Selecting a Basis for Predicting Shipping Expenses (Requires Computer Spreadsheet*)

Penn Company assembles and sells computer boards in western Pennsylvania. In an effort to improve the planning and control of shipping expenses, management is trying to determine which of three variables-units shipped, weight shipped, or sales value of units shipped has the closest relationship with shipping expenses. The following information is available:

Month	Units Shipped	Weight Shipped (lbs)	Sales value of Units Shipped	Shipping Expenses
May	3,000	6,200	$100,000	$5,600
June	5,000	8,000	110,000	7,700
July	4,000	8,100	80,000	6,500
August	7,000	10,000	114,000	10,400
September	6,000	7,000	140,000	8,600
October	4,500	8,000	160,000	8,200

Required:-

a. With the aid of a spreadsheet program, determine whether units shipped, weight shipped or sales value of units shipped has the closest relationship with shipping expenses.

b. Using the independent variable that appears to have the closest relationship to shipping expenses, develop a cost-estimating equation for total monthly shipping expenses.

c. Use the equation developed in requirement (b) to predict total shipping expenses in a month when 5,000 units, weighing 7,000 lbs., with a total sales value of $114,000 are shipped.

Reference no: EM13950682

Questions Cloud

Are you more impressed with the "greatness" of empires : Are you more impressed with the "greatness" of empires or with their destructive and oppressive features? Why? Do you think that the classical empires hold "lessons" for the present, or are contemporary circumstances sufficiently unique to render the..

Alcohol and public health : Need to cover all these topics in the report - Assignment need to be fully plagiarism free and unique. Need to follow all the heading as I have given in descriptions with 1800 words limit no less with 8 to 10 references.

Calculate the preferred and common stockholders equity claim : Calculate the preferred and common stockholders' equity claim on Kim Company's retained earnings balance at January 1, 20X7.

Describe the number of arrivals per unit of time : Experience suggests that 4 percent of all college students have had a tonsillectomy. In a sample of 300 college students, we need to find the probability that at least 10 have had a tonsillectomy. It is acceptable to use the normal distribution to..

Penn company assembles and sells computer : Penn Company assembles and sells computer boards in western Pennsylvania. In an effort to improve the planning and control of shipping expenses, management is trying to determine which of three variables

Write the syntax (one line) to declare an int array : Write the syntax using a loop to print out every odd value from the array above

The most basic concept of kant ethics is truth : The most basic concept of Kant's ethics is truth. Immanuel Kant revised Bentham's ideas by arguing for the importance of differences in the type, kind, or quality of pleasures and pains that follow from actions

Prepare determination of excess schedul schedule for cipher : Prepare the determination and distribution of excess schedule for Cipher Corporation's purchase of Doer Company common stock on January 1, 20X3.

What is the probability that male student was born in miami : A poll was taken to determine the birthplace of a class of college students. Below is a chart of the results. What is the probability that a female student was born in Orlando?

User Account

All Pages