Prepare worksheet that can calculate the total insurance due

Reference no: EM13906726

The fire insurance premium on factories is £10 per square metre of floor space if that space is 500 m² or less, but £15 per m² for all larger areas.

(a) Prepare a worksheet that can calculate the total insurance due when the floor space of the factory is entered.

(b) Prepare a suitably labelled and titled graph showing how the total insurance due varies with the floor space of the factory for any range of floor spaces that are entered.

Reference no: EM13906726

Questions Cloud

Materials are added at the start of the process : The following information pertains to the Ralph Company: Materials are added at the start of the process. How many equivalent units for conversion costs would there be using the FIFO method?

How much income must bjorn report from these businesses : Bjorn owns a 35% interest in an S corporation that earned $200,000 in 2010. He also owns 10% of the stock in a C corporation that earned $200,000 during the year. The S corporation distributed $10,000 to Bjorn and the Corporation paid dividends of $1..

Required EPS figures that must appear on income statement : Convertible, cumulative preferred stock: 20,000 shares, each convertible into 100 shares of common issued on October 1, 2013, $1000 face, 6% annual dividends which are declared and paid quarterly, but in the fourth quarter, 2013, the quarterly divide..

Different savings plans-which one used the better strategy : John and twin sister June have different savings plans. John starts investing with a $7,000 deposit today, and will add $7,000 at the end of each of the next 8 years (for a total of 9 deposits). For each cash flows explained above, how much will each..

Prepare worksheet that can calculate the total insurance due : Prepare a worksheet that can calculate the total insurance due when the floor space of the factory is entered. how the total insurance due varies with the floor space of the factory for any range of floor spaces that are entered.

Total costs both fixed and variable : Total fixed costs for Herman Enterprises are $215911. Total costs, both fixed and variable, are $558749 if 100,000 units are produced. The variable cost per unit is: (input your number without dollar signs or commas. Use two decimal places.)

Developing global partnerships to solve international health : Developing global partnerships to solve international health problems 6SOURCES (2008 to 2015) Based on the review of global health disparities across both inter/intra national countries, and using epidemiological analytical methods to infer the fa..

Explain what you interpret about the target audience : Choose at least one site, such as a page from a blog, Facebook, Twitter, LinkedIn, or other online artifact and evaluate the message that is conveyed from what you observe from this digital footprint.

Use of worksheet in preparing statement of cash flows : Explain the use of a worksheet in preparing a statement of cash flows. When numerous adjustments are necessary or other complicating factors are present, companies often use a worksheet to assemble and classify the data that will appear on the statem..

User Account

All Pages