Using VBA Excel and Option Explicit You start a company selling Catbots, cute robotic cats You have two models Model Price Weight (kilos) Darth 1000 $159 1 1 SayTen 44b $299 1 9 Write a program to compute the price of an order It reports shipping cost, and total cost The program starts like this Customers enter the number of each bot they want Check that the data is numeric, and between zero and five inclusive Show an error message if the data is bad For example Shipping cost depends on the order Orders for $1,000 or more (excluding shipping) are shipped for free Otherwise, shipping is $4 per kilo For example Use the IPO pattern, that is, separate subs for input, processing, and output 1 Catbots Order 3 How many of each do you want 5 Darth 1000 6 Say Ten 45b Compute 10 Shipping 11 12 Total 1 Catbots Order 3 How many of each do you want 5 Darth 1000 6 Say Ten 45b Compute 10 Shipping 11 12 Total

The Answer is in the image, click to view ...

Question: Using VBA Excel and Option Explicit You start a company selling Catbots, cute robotic cats. You have two models: Model Price Weight (kilos) Darth 1000

Using VBA Excel and Option Explicit

You start a company selling Catbots, cute robotic cats. You have two models:

Model	Price	Weight (kilos)
Darth 1000	$159	1.1
SayTen 44b	$299	1.9

Write a program to compute the price of an order. It reports shipping cost, and total cost. The program starts like this:

Using VBA Excel and Option Explicit You start a company selling Catbots,

Customers enter the number of each bot they want. Check that the data is numeric, and between zero and five inclusive. Show an error message if the data is bad. For example:

cute robotic cats. You have two models: Model Price Weight (kilos) Darth

Shipping cost depends on the order. Orders for $1,000 or more (excluding shipping) are shipped for free. Otherwise, shipping is $4 per kilo. For example:

1000 $159 1.1 SayTen 44b $299 1.9 Write a program to compute

the price of an order. It reports shipping cost, and total cost.

Use the IPO pattern, that is, separate subs for input, processing, and output.

1 Catbots Order 3 How many of each do you want? 5 Darth 1000 6 Say Ten 45b Compute 10 Shipping 11 12 Total 1 Catbots Order 3 How many of each do you want? 5 Darth 1000 6 Say Ten 45b Compute 10 Shipping 11 12 Total

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Exercise: Catbots You start a company selling Catbots, cute robotic cats. You have two models: Model Price Weight (kilos) Darth 1000 $159 1.1 SayTen 44b $299 1.9 Write a program to compute the price...

Using VBA Excel and Option Explicit and IPO Please :) Exercise: Xoop panel candidates Elections are coming up on Xoop, a planet about 58 light years from Earth. Plinth, a political journalist, wants...

USING VBA EXCEL AND OPTION EXPLICIT Youre having a dinner party. Youre inviting couples, their children, and dogs. Youre not sure who youll invite yet. Write a program to work out how many place...

USING VBA EXCEL AND OPTION EXPLICIT AND IPO PLEASE :) Exercise: Puffin length Download a workbook with data on the length of puffins. It looks like this: (Total obs means Total observations.) Most...

USING VBA EXCEL AND OPTION EXPLICIT RPGs are role playing games, like Zelda, and Final Fantasy. RPG characters often have a class, like fighter, thief, or wizard. Write a program that shows the base...

USING VBA EXCEL AND OPTION EXPLICIT Write a program to compute the price of renting an animal from Ulmas Ungulates. You can rent either a llama, or a camel. The price depends on: Which animal you...

USING VBA EXCEL AND OPTION EXPLICIT Redo the favorite animal program with different I/O. Thats geek for input/output. Get data from the keyboard, and show output to the screen. Also, add two more...

USING VBA EXCEL AND OPTION EXPLICIT The cargo teleporter from Earth to Mars operates between 3 am and 11 am every day. Write a program that computes the price of sending cargo at a particular time....

Using VBA Excel and Option Explicit Write a program to help small towns estimate the length of parades, like their July 4th parade. Parades have floats and marching bands. Each float needs 30 meters....

USING VBA EXCEL AND OPTION EXPLICIT The scientific name of a species has two components: genus, and species. For example, the blue whale is balaenoptera musculus. Write a program to parse a...

The difference in pH between the internal and external surfaces of the inner mitochondrial membrane is 1.4 pH units (external side acidic). If the membrane potential is 0.06 V (inside negative), what...

A certain reaction was run several times using each of two catalysts, A and B. The catalysts were supposed to control the yield of an undesirable side product. Results, in units of percentage yield,...

How can companies enhancer AIS an internal controls to better manage cash and receivable

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

___ 4. Security and stability are more important to me than freedom and autonomy.

___ 2. I am most fulfilled in my work when I have been able to integrate and manage the efforts of others.

___ 6. I will feel successful in my career only if I have a feeling of having made a real contribution to the welfare of society.